excecute a procedure [message #351830] |
Fri, 03 October 2008 07:03  |
lota
Messages: 1 Registered: October 2008 Location: Namur
|
Junior Member |
|
|
I write a procedure xxlbk_hr_callcenter
in a package Xxlbk_Interface_Comm_Pkg build in a schema APPS_AOL93.
I write a toto.sql to execute this procedure.
in toto.sql I put this code:
SET SERVEROUTPUT ON
WHENEVER SQLERROR EXIT SQL.SQLCODE
begin
Execute APPS_AOL93.Xxlbk_Interface_Comm_Pkg.xxlbk_hr_callcenter('','0');
end;
/
After excecution I have the following message. Can somebody can help me to solve this problem. [I don't know kown to give default value to retcode and errcode]
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Execute APPS_AOL93.Xxlbk_Interface_Comm_Pkg.xxlbk_hr_callcenter('','0');
*
ERROR at line 2:
ORA-06550: line 2, column 9:
PLS-00103: Encountered the symbol "APPS_AOL93" when expecting one of the
following:
:= . ( @ % ; immediate
The symbol ":=" was substituted for "APPS_AOL93" to continue.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ERROR
-------------------------------
Anywhy a try this code in tot.sql:
REM SET TERMOUT ON = Do not suppres the display of output, errors
REM SET VERIFY OFF = Do not ask values for parameters
REM SET FEEDBACK OFF = Suppress the display of numbers returned by a query
SET TERMOUT ON
SET VERIFY OFF
SET FEEDBACK OFF
WHENEVER SQLERROR EXIT SQL.SQLCODE
declare
Variable errbuf VARCHAR2(200):=NULL;
Variable retcode VARCHAR2(200):=NULL;
begin
Execute APPS_AOL93.Xxlbk_Interface_Comm_Pkg.xxlbk_interf_comm(errbuf,retcode);
end;
/
It return also error.
Thanks for your help !!
|
|
|
|
Re: excecute a procedure [message #351853 is a reply to message #351830] |
Fri, 03 October 2008 08:24  |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
declare
Variable errbuf VARCHAR2(200):=NULL;
Variable retcode VARCHAR2(200):=NULL;
begin
Execute APPS_AOL93.Xxlbk_Interface_Comm_Pkg.xxlbk_interf_comm(errbuf,retcode);
end;
/
Welcome to the forum.
First of all, you shall realize the difference between PL/SQL language and SQL*Plus commands. Both of them are deeply described in the documentation, found e.g. online on http://tahiti.oracle.com/.
EXECUTE is not PL/SQL command, so it cannot be used inside the PL/SQL block.
Also I am curious, how you come to the "Variable" identificator, as it is incorrect too.
|
|
|