Home » SQL & PL/SQL » SQL & PL/SQL » excecute a procedure (oracle 9i on Aix server)
excecute a procedure [message #351830] Fri, 03 October 2008 07:03 Go to next message
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 #351837 is a reply to message #351830] Fri, 03 October 2008 07:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Also, carefully choose the forum.

Regards
Michel
Re: excecute a procedure [message #351853 is a reply to message #351830] Fri, 03 October 2008 08:24 Go to previous message
flyboy
Messages: 1832
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.
Previous Topic: db jobs
Next Topic: Error in Trigger
Goto Forum:
  


Current Time: Sun Dec 04 20:47:59 CST 2016

Total time taken to generate the page: 0.08378 seconds