HELP! SQLPLUS and PACKAGES
Date: 2000/02/29
Message-ID: <nQXu4.300$dD6.48764_at_sapphire.mtt.net>#1/1
Hello,
I have a script that executes a package, it contains:
BEGIN
rpt45.main_rpt45 (&1, '&2');
END;
/
If I execute the script using the parms 24601 and TRXID I get:
old 2: rpt45.main_rpt45 (&1, '&2');
new 2: rpt45.main_rpt45 (24601, 'TRXID');
BEGIN
*
ERROR at line 1:
ORA-06550: line 2, column 9:
PLS-00201: identifier
'RPT45.MAIN_RPT45' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
If I go into sqlplus and enter:
1 BEGIN
2 rpt45.main_rpt45 (&1, '&2');
3* END;
SQL> /
Enter value for 1: 24601
Enter value for 2: TRXID
old 2: rpt45.main_rpt45 (&1, '&2');
new 2: rpt45.main_rpt45 (24601, 'TRXID');
PL/SQL procedure successfully completed.
It works why?
Thanks in advance
Greg
Received on Tue Feb 29 2000 - 00:00:00 CET