SQL Developer [message #652879] |
Tue, 21 June 2016 09:20 |
|
indupriya_v
Messages: 1 Registered: June 2016 Location: Chennai
|
Junior Member |
|
|
I'm used to SQLPlus and Toad. When I execute this in Oracle SQLDeveloper it gives error.
How to execute in SQLDeveloper.
CREATE OR REPLACE PACKAGE GRPSCHEMA.PKG_UPLOAD_GROUPDETAILS IS
PROCEDURE GRPSCHEMA.PRC_UPLOAD_GROUPDETAILS(
P_REQUEST_ID IN NUMBER,
P_STATUS_CODE OUT VARCHAR2) ;
END PKG_UPLOAD_GROUPDETAILS;
|
|
|
Re: SQL Developer [message #652880 is a reply to message #652879] |
Tue, 21 June 2016 09:46 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Doesn't work in SQLPlus either, you will have to correct the syntax.
SQL> CREATE OR REPLACE PACKAGE GRPSCHEMA.PKG_UPLOAD_GROUPDETAILS IS
2
3 PROCEDURE GRPSCHEMA.PRC_UPLOAD_GROUPDETAILS(
4 P_REQUEST_ID IN NUMBER,
5 P_STATUS_CODE OUT VARCHAR2) ;
6
7 END PKG_UPLOAD_GROUPDETAILS;
8 /
Warning: Package created with compilation errors.
SQL> show errors
Errors for PACKAGE GRPSCHEMA.PKG_UPLOAD_GROUPDETAILS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/14 PLS-00103: Encountered the symbol "." when expecting one of the
following:
( ; is with authid as cluster order using external
deterministic parallel_enable pipelined result_cache
4/17 PLS-00103: Encountered the symbol "NUMBER" when expecting one of
the following:
(
5/29 PLS-00103: Encountered the symbol ";" when expecting one of the
following:
return
( it guess that SQLDeveloper automatically displays the syntax errors after compilation )
[Updated on: Tue, 21 June 2016 09:49] Report message to a moderator
|
|
|
Re: SQL Developer [message #652884 is a reply to message #652880] |
Tue, 21 June 2016 12:07 |
Frank Naude
Messages: 4589 Registered: April 1998
|
Senior Member |
|
|
The package name can have a schema prefixed to it, but the embedded procedure cannot.
Hence, c/GRPSCHEMA.PRC_UPLOAD_GROUPDETAILS/PRC_UPLOAD_GROUPDETAILS/
|
|
|