>I'm using SQL Studio to try to port a stored proc from Oracle
>into MaxDB
>without any success. I'm using SQL Execute.
>
>I get a great many errors, and it seems that it is executing each line
>individually, rather than treating the whole block of code as
>the body of
>the dbproc. What am I doing wrong? I tried 'delimiter //'
MaxDB does not support control statements in regular SQL, but only in a DBPROC
definition.
So you should enter the following:
CREATE OR REPLACE DBPROC myproc ...
//
CALL myproc ('value1', 'value2')
This would create the DBProc and execute the first test with one execute.
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
