Skip to Content
0
Former Member
Nov 06, 2007 at 12:16 PM

Calling a stored procedure from query template

111 Views

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 .