Hi,
I am beginner. Please help.
I have a stored procedure in a package and I saved this locally. I am
not able to execute the procedure from command line. Stored the
following code in pkg_test_global.sql file on my local machine. I am
on Linux.
CREATE OR REPLACE PACKAGE pack_test_globals IS
v_public NUMBER :=0;
procedure increase_and_display;
end pack_test_globals;
CREATE OR REPLACE PACKAGE BODY pack_test_globals IS
v_private number:= 0;
procedure increase_and_display IS
v_local NUMBER:= 0;
BEGIN
v_public := v_public + 1;
v_private := v_private + 1;
v_local := v_local + 1;
DBMS_OUTPUT.PUT_LINE('PUBLIC VARIABLE IS -----' || v_public);
DBMS_OUTPUT.PUT_LINE('PRIVATE VARIABLE IS -----' || v_private);
DBMS_OUTPUT.PUT_LINE('LOCAL VARIABLE IS -----' || v_local);
END increase_and_display;
END pack_test_globals;
SQL>@/home/ranganah/DBRelated/pkg_test_global.sql
Warning: Package created with compilation errors.
How do I see these warnings with compilation errors and how to resolve
this?
When I tried to call the procedure I get this error. How to get over
it. ?
SQL>exec /home/ranganah/DBRelated/
pack_test_globals.increase_and_display;
BEGIN /home/ranganah/DBRelated/pack_test_globals.increase_and_display;
END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
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 pipe
Please Help me resolve this. I am blocked.
Thanks,
Sam
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
