Oracle Error Pls 00321
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us pls-00321 bulk collect into Learn more about Stack Overflow the company Business Learn more about hiring developers
Pls-00642: Local Collection Types Not Allowed In Sql Statements
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up PLS-00321 Error up vote 0 down vote favorite I have declared a record as below TYPE pg_wad_usr_portgrp_rec IS RECORD ( user_id npe_user.user_id%TYPE, Portal_grp_name npe_portal_grp.protal_group_name%TYPE ); When am using the same value in the below procedure am getting error PROCEDURE add_rmv_usr_portal_grp ( p_user_portal_grp IN pg_wad_usr_portgrp_tab, p_status OUT VARCHAR2 ) Begin pg_wad_usr_portgrp_rec := p_user_portal_grp; Error : 02:34:11.795 DBMS npeproc -- PLS-00321: expression 'PG_WAD_USR_PORTGRP_REC' is inappropriate as the left hand side of an assignment statement plsqldeveloper share|improve this question edited Dec 16 '15 at 9:44 Kevin Guan 10.8k92648 asked Feb 27 '13 at 8:46 Mathankumar Chandrasekaran 11 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote The expression does not designate a variable that can have a value assigned to it. For example, the function SYSDATE cannot appear on the left hand side of an assignment statement TYPE pg_wad_usr_portgrp_rec IS RECORD ( user_id npe_user.user_id%TYPE) pg_wad_usr_portgrp_data pg_wad_usr_portgrp_rec; share|improve this answer answered Nov 26 '13 at 12:19 UMUT 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged plsqldeveloper or ask your own question. asked 3 years ago viewed 926 times active 10 months ago Related 0Simple Oracle Stored Procedure getting Invalid object error1Overloading problem: Error(83,5): PLS-00307: too many declarations of 'REPORTEQ' match this call-1How to solve numeric or value error?-1Error in executing a string dynamically0compliat
#301069] Tue, 19 February 2008 02:23 xenium Messages: 25Registered: February 2008 Location: Leuven Belgium Junior Member I'm writing a test framework to test all the functions and procedures of a database. I have made a package pkgrun with several procedures in. Each procedure calls an other procedure. The commands to test the functions and procedures are stored in the table command. Some commands returns a cursor and there I've got a problem to catch the cursor. I get the http://stackoverflow.com/questions/15107636/pls-00321-error error: Quote: Warning: execution completed with warning PACKAGE BODY pkgrun Compiled. 81/14 PLS-00321: expression 'TESTRESULT_CURSOR_V' is inappropriate as the left hand side of an assignment statement The procedure start_command (with line 81 is): PROCEDURE start_command (testtype_v IN VARCHAR2, command_v IN VARCHAR2, testvalue_v IN VARCHAR2, id_command_v IN NUMBER, id_run_v IN NUMBER, returntype_v IN VARCHAR2) IS test_result_v VARCHAR2(100); testresult_number_v http://www.orafaq.com/forum/t/97536/ NUMBER; TYPE testresult_cursor_v IS REF CURSOR; number_rows NUMBER; BEGIN IF testtype_v = '' THEN EXECUTE IMMEDIATE command_v; ELSE IF returntype_v = 'NUMBER' THEN EXECUTE IMMEDIATE command_v INTO testresult_number_v; test_result_v := to_char(testresult_number_v); ELSIF returntype_v = 'CURSOR' THEN EXECUTE IMMEDIATE command_v INTO testresult_cursor_v; number_rows := testresult_cursor_v%ROWCOUNT; test_result_v := to_char(number_rows); ELSE EXECUTE IMMEDIATE command_v INTO testresult_v; END IF; testresult_v := to_char(testresult_v); test_value(testtype_v, testvalue_v, testresult_v, id_command_v, id_run_v); END IF; END start_command; Line 81 is: INTO testresult_cursor_v; ELSIF returntype_v = 'CURSOR' THEN EXECUTE IMMEDIATE command_v INTO testresult_cursor_v; number_rows := testresult_cursor_v%ROWCOUNT; test_result_v := to_char(number_rows); Report message to a moderator Re: PLS-00321: expression 'TESTRESULT_CURSOR_V' is inappropriate as the left hand side of an assignm [message #301089 is a reply to message #301069] Tue, 19 February 2008 03:16 dhananjay Messages: 635Registered: March 2002 Location: Mumbai Senior Member a couple of points. you have declared a type as refcursor.but your are missing a variable declaration of ref cursor; Quote:TYPE testresult_cursor_v IS REF CURSOR; var_name testresult_cursor_v; missing in your code Quote:EXECUTE IMMEDIATE command_v INTO testresult_cu
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-00321 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it https://www.experts-exchange.com/questions/21458796/Error-executing-and-passing-values-to-a-successfully-compiled-Oracle-Procedure.html enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University oracle error TrainingOracle VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace oracle error pls depthSubspace depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , rev
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error executing and passing values to a successfully compiled Oracle Procedure. Want to Advertise Here? Solved Error executing and passing values to a successfully compiled Oracle Procedure. Posted on 2005-06-15 Oracle Database 1 Verified Solution 6 Comments 143 Views Last Modified: 2010-03-22 Hi, I created a simple Oracle procedure that should take an in value and return a value. The proc will get more complex, but it's not working with this first part. I've written many Oracle procs before but none that take input and provide output. The proc compiles with no errors, but I get an error when I try to execute it. I'm including the code and the error returned upon execution below. Thanks in advance for your assistance. ## Code to create ## create or replace procedure ssn_proc (input_cds IN char, return_value IN OUT char) is cursor ssn_cursor is select ssn_id from indicative_data where cds_id = input_cds; ssn_out char(9); begin open ssn_cursor; fetch ssn_cursor into ssn_out; if ssn_cursor%FOUND then return_value := 'Y'; return; else if ssn_cursor%notfound then return_value := 'N'; return; end if; end if; close ssn_cursor; end; / ### Error when executing ### ## I think the error may be just because of the way I am passing the variable upon execution. Thanks again in advance for your assistance. SQL> exec ssn_proc := "wxyz"; BEGIN fordssn_proc := "wxyz"; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00321: expression 'FORDSSN_PROC' is inappropriate as the left hand side of an assignment statement ORA-06550: line 1, column 7: PL/SQL: Statement ignored 0 Question by:ghanrahan Facebook Twitter LinkedIn Google LVL 23 Best Solution bypaquicuba This is worng -- > SQL> exec ssn_proc := "wxyz"; Change you procedure to: create or replace procedure ssn_proc (input_cds IN char, return_value OUT char) is cursor ssn_cursor is select Go to Solution 6 Comments LVL 11 Overall: Level 11 Oracle Database 7 Message Expert Comment by:cjjclifford2005-06-15 DECLAR