SQLPLSQLCommand Procedure Error

General discussion forum about all databases other than SqlBase.
venkat.saggitarious

SQLPLSQLCommand Procedure Error

Post by venkat.saggitarious » 21 Sep 2011, 15:05

Hi,

I'm passing long string single dimensional array IN/OUT arguments to an SP using the function SqlPLSQLCommand. When the SP returns less than 30 records the data is being correctly sent to the TD1.5 which can be accessed in the array receive arguments but when the SP returns more than 30 records then the TD1.5 returns error and crashes. In the SP the corresponding arguments are declared as OUT parameters. Kindly help me out with this issue as i'm struck here for a long time.

Thanks,
Venkat

jmcnamara

Re: SQLPLSQLCommand Procedure Error

Post by jmcnamara » 26 Sep 2011, 14:39

SalStrSetBuffer... will probably solve your problem. You may have to do it for each elemet the array might returen. Dirty, but might work.

venkat.saggitarious

Re: SQLPLSQLCommand Procedure Error

Post by venkat.saggitarious » 27 Sep 2011, 05:56

Thanks JMC for your help, i'll try and revert back.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests