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
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 .