Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calling a stored procedure from query template

Dear All,

I have created one stored procedure in oracle database. I need to call it from a query template. Can any tell me how I can call it from query template?

I am writing following in the query template

Begin

Exec <PackName>.<procName>;

End;

But it is giving me error.

A SQL Error has occurred on query, 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 <a single-quoted SQL string> pipe <an alternatively-quoted SQL string> The symbol "declare was inserted before "" to continue. ORA-06550: line 2, column 15: PLS-00103: Encountered the symbol "" when expecting one of the following: begin function package pragma procedure subtype type use <an identifier> <a double-quoted delimited-identifier> form current cursor .

Former Member
Not what you were looking for? View more on this topic or Ask a question