SQL Developer [message #652879] |
Tue, 21 June 2016 09:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2adf07d680fc4a083b51ee93bc473754?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3211 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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Frank Naude
Messages: 4580 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/
|
|
|