Calling Stored Procedure with LONGVAR: Parameter Type?

[shaunb]

If you have a column type of LONGVAR:
e.g.

Code: Select all

NAME COLTYPE
======== ========
MSGTEXT LONGVAR

What type of parameter do you need to specify in a stored procedure to receive it?

e.g.

Code: Select all

CREATE TRIGGER SYSADM."PROBLEM" AFTER INSERT ON SYSADM.PROBLEM_TABLE
(EXECUTE INLINE(MSGTEXT)
PROCEDURE P1 STATIC
Parameters
What-Type-Goes-Here : sMsgText
Local Variables
Actions
)
FOR EACH ROW;

[Steve Leighton]

.
Use a RECEIVE LONG STRING: sMsgText e.g.

Code: Select all

PROCEDURE: sp_GetMsgText static
PARAMETERS
 RECEIVE LONG STRING: sMsgText
LOCAL VARIABLES
 Sql Handle: hSql
 Number: nFetched
ACTIONS
	!--------------------------------------------------------------------------------------
	!--Stored Proc returning a Long String
	!--------------------------------------------------------------------------------------
	On Procedure Startup
		Call SqlConnect(hSql)
	On Procedure Execute
			Call SqlPrepareAndExecute(hSql, '
							Select 	Your Long String Here
	    						From 	Your Table
							Into		:sMsgText' )
	On Procedure Fetch
		If SqlFetchNext(hSql, nFetched)
			Return 0
		Else
			Return 1
	On Procedure Close
		Call SqlDisconnect(hSql)

[shaunb]

Superb! Thank you, Steve.