Im trying to use perls DBI interface to run DDL SQL scripts against the database. I have a stored procedure which runs fine from SQL Studio but when I try to run it using my perl DBI interface it throws this error:
DBD::ODBC::db prepare failed: [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-5015 POS(318) Missing keyword:RETURN,FETCH,CLOSE,WHILE,UPDATE,TRY,SUBTRANS,STOP,SET. (SQL-42000)(DBD: st_prepare/SQLPrepare err=-1) at ReadSqlFile.pl line 38, <FD> line 11. Can't prepare statement: CREATE DBPROC PR_GetNextSeqNumber (IN i_SequenceName VARCHAR(50) , OUT o_SeqNumber INT ) AS
The first step would be to use the information POS (318) to see where the error is actually happening. Just remember that POS (1) is the first character of the SQL statement.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
