|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Creating Package error
CREATE OR REPLACE PACKAGE
fac_web_tigers_intf_pkg AS PROCEDURE fac_tiger_intf_checking_p; END fac_web_tigers_intf_pkg; CREATE OR REPLACE PACKAGE BODY fac_web_tigers_intf_pkg AS PROCEDURE fac_tiger_intf_checking_p IS lv_dept VARCHAR2(240); lv_entity VARCHAR2(240); lv_entity_desc VARCHAR2(240); lv_sector VARCHAR2(240); lv_sector_desc VARCHAR2(240); lv_book_type VARCHAR2(240); lv_CID VARCHAR2(30); lv_fullname VARCHAR2(240); CURSOR c_temp_curs IS SELECT commerce_id ,dept FROM fac_web_tigers_temp WHERE error = 'P' FOR UPDATE OF ERROR; END END fac_web_tigers_intf_pkg; This is the error that i got: PLS-00103: Encountered the symbol "CREATE" |
|
#2
|
|||
|
|||
|
Please note the miner modificatiin in your procedure marke with red color.
CREATE OR REPLACE PACKAGE fac_web_tigers_intf_pkg AS PROCEDURE fac_tiger_intf_checking_p; END fac_web_tigers_intf_pkg; / CREATE OR REPLACE PACKAGE BODY fac_web_tigers_intf_pkg AS PROCEDURE fac_tiger_intf_checking_p IS lv_dept VARCHAR2(240); lv_entity VARCHAR2(240); lv_entity_desc VARCHAR2(240); lv_sector VARCHAR2(240); lv_sector_desc VARCHAR2(240); lv_book_type VARCHAR2(240); lv_CID VARCHAR2(30); lv_fullname VARCHAR2(240); CURSOR c_temp_curs IS SELECT commerce_id ,dept FROM fac_web_tigers_temp WHERE error = 'P' FOR UPDATE OF ERROR; END END fac_web_tigers_intf_pkg; This code suppose to work fine as long as you save it as file then run it as follows: SQL>@mypackage.sql |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Creating Package error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|