on 11-06-2007 12:16 PM
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 .
Hi Vishal,
Deleted the other thread to prevent duplication.
Please do not double post and always search before posting.
Cheers
Abesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.