Home » Other » Client Tools » SQL Developer
SQL Developer [message #652879] Tue, 21 June 2016 09:20 Go to next message
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 messageGo to next message
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
Frank Naude
Messages: 4579
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/
Previous Topic: Turning Off "Generate DDL" In Data Modeler
Next Topic: No scheduler option available in sql developer
Goto Forum:
  


Current Time: Thu Mar 28 11:52:03 CDT 2024