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.

Thread Tools Display Modes
Share |
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.

CREATE OR REPLACE PACKAGE film_pkg IS title VARCHAR2(100); PROCEDURE get_films(fname VARCHAR2); END film_pkg;
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;
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



Go Back   Webmaster Forum > Web Development > Coding Forum


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 11:42 AM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC