Skip to Content
avatar image
Former Member

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 .

 
 
 

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 06, 2007 at 08:20 PM

    Vishal,

    Why are there 2 posts on the same subject? Maybe you should close the other one and I would recommend searching the forum for several previous discussions on Oracle Stored Procedures, such as: Problem Executing Oracle Stored Procedure

    Regards,

    Jeremy

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2007 at 06:49 AM

    Hi Vishal,

    Deleted the other thread to prevent duplication.

    Please do not double post and always search before posting.

    Cheers

    Abesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear All,

      Sorry for any inconvenience caused due to double posting my problem.

      The first one was not in proper format, thatÂ’s why I posted the second one.

      Initially I was not aware of how to delete a thread.

      But now I have deleted that.

      Once again, Sorry for any inconvenience.