AnsweredAssumed Answered

Can we run stored procedures in SQL Database Execution step (JDBC) in LISA testcase?

Question asked by anpanday on Feb 26, 2015
Latest reply on Mar 3, 2015 by anpanday

Hi All,

 

Is there a way we can run stored procedures in SQL Database Execution step (JDBC) in LISA testcase?

 

We are trying to run below command

 

begin

VOIP_SERVICES.PUT_SIP_30;

end;

 

Where PUT_SIP_30 is the body of stored procedure in Oracle database and VOIP_SERVICES is the procedure name

 

Getting below error while executing above procedure which is running fine in SQL developer:

 

There was SQLException: java.sql.SQLException: ORA-06550: line 1, column 6:

PLS-00103: Encountered the symbol "" when expecting one of the following:

   begin case declare exit for goto if loop mod null pragma

   raise return select update while with <an identifier>

   <a double-quoted delimited-identifier> <a bind variable> <<

   close current delete fetch lock insert open rollback

   savepoint set sql execute commit forall merge pipe

The symbol "begin was inserted before "" to continue.

ORA-06550: line 2, column 26:

PLS-00103: Encountered the symbol "" when expecting one of the following:

   begin case declare end exception exit for goto if loop mod

   null pragma raise return select update while with

   <an identifier> <a double-quoted delimited-id

 

Thanks,

Ankush

Outcomes