[sqr-users] Maximum size of Out parameters with Oracle and SQR

["McDowall, Alasdair (NZ)" <AlasdairM@swiftenergy.com>]

Hi

 

I am trying to pass and receive parameters from an Oracle Stored Procedure
in SQR but have hit a 30 character limit on OUT parameters. Using SQR6 and
Oracle8. Here is a sample of the code.

 

begin-procedure Test( $InParameter,:$OutParameter)

 

begin-sql On-Error=ErrorProc ('Test', $sql-error)

begin

aPackage.aProcedure($InParameter, $OutParameter);;

end;;

END-SQL

 

end-procedure

 

If $OutParameter is less than 30 characters it works. Is there some SQR.ini
setting I have missed? Any comments much appreciated.

 

Al

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users