Webmaster Forum

Go Back   Webmaster Forum > Web Development > Coding Forum

Coding Forum Problems with your code? Discuss coding issues, including JavaScript, PHP & MySQL, HTML & CSS, Flash & ActionScript, and more.


Reply
 
Thread Tools Display Modes
Share |
  #1  
Old 10-16-2017, 05:30 AM
seodaikaads seodaikaads is offline
Contributing Member
 
Join Date: 05-02-14
Posts: 188
iTrader: 0 / 0%
Oracle Error PLS-00323

Can someone help me put my SQL procedure in a package? I've tried and I'm fighting with it.

Code:
Code:
CREATE OR REPLACE PACKAGE film_pkg IS title VARCHAR2(100); PROCEDURE get_films(fname VARCHAR2); END film_pkg;
Code:
Code:
CREATE OR REPLACE PACKAGE BODY film_pkg IS PROCEDURE get_films (fname IN film.title%TYPE, r_date OUT film.release_date%TYPE, dur OUT film.duration%TYPE) AS BEGIN SELECT release_date, duration INTO r_date, dur FROM FILM WHERE title = fname; EXCEPTION WHEN NO_DATA_FOUND THEN r_date := ''; dur := ''; END get_films; END film_pkg;
Code:
Code:
Error(4,11): PLS-00323: subprogram or cursor 'GET_FILMS' is declared in a package specification and must be defined in the package
 
Reply With Quote

Advertisement

Advertisement

Go Back   Webmaster Forum > Web Development > Coding Forum

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 07:48 PM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC