Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old July 20th, 2004, 11:05 PM
alant80 alant80 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 1 alant80 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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"

Reply With Quote
  #2  
Old July 21st, 2004, 07:52 AM
shafique shafique is offline
Senior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Canada
Posts: 305 shafique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 6
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Creating Package error


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT