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
BEGIN
UPDATE DevUser.SystemSequences
SET CurrentSequenceNo = CurrentSequenceNo +1
WHERE SequenceName = :i_SequenceName;
SELECT CurrentSequenceNo INTO :o_SeqNumber
FROM DevUser.SystemSequences
WHERE SequenceName = :i_SequenceName;
END;;
DBI::errstr()
Im running SAPDB version 7.4.3.17 on windows 2000. And I have no problem
running table creation DDL from this perl interface.
******************************************************************************************************************************************************
This e-mail has been prepared using information believed by the author to be
reliable and accurate, but Thales Information Systems Finance makes no
warranty as to accuracy or completeness. In particular Thales Information
Systems Finance does not accept responsibility for changes made to this
e-mail after it was sent. Any opinions expressed in this document are those of
the author and do not necessarily reflect the opinions of the company or its
affiliates. They may be subject to change without notice.
This e-mail, its content and any files transmitted with it are intended
solely for the addressee(s) and may be legally privileged and/or
confidential. Access by any other party is unauthorised without the express
written permission of the sender. If you have received this e-mail in error you
may not copy or use the contents, attachments or information in any way.
Please destroy it and contact the sender via the Thales Information Systems
Finance switchboard in London at +44 (0) 20 7650 0100 or via e-mail return.
This message and any attachments have been scanned
for viruses prior to leaving the originators network. The originator does not
guarantee the security of this message and will not be responsible for any
damages arising from any alteration of this message by a third party or as a
result of any virus being passed on.
*******************************************************************************************************************************************************
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
