Pls-801 Internal Error 55018
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 Learn more about Stack Overflow the company ora-06553: pls-801: internal error [pklsdlp:dependency verification] Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs ora-06553 pls-801 internal error 56327 Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers,
Ora-06553 Pls-801 Internal Error 56319
just like you, helping each other. Join them; it only takes a minute: Sign up PL / SQL Function to return varchar2 / numbers up vote 2 down vote favorite I have this PL / SQL function that accepts the name of a student (f_name). The function then displays all of the information for the given student from a premade table called students. The table contains 5 columns, 2 number type, and 3 varchar2 type. If the name isn't found in the table an error message is returned. My code so far is CREATE OR REPLACE FUNCTION studentName( f_name IN VARCHAR2) RETURN IS v_test students%rowtype; CURSOR c1 IS SELECT * FROM students WHERE first_name = f_name; BEGIN OPEN c1; FETCH c1 INTO v_test; IF c1%notfound THEN v_test := NULL; END IF; CLOSE c1; RETURN v_test; END; I keep getting: PLS-00382: expression is of wrong type I believe from my initial return varchar2 statement. How do I allow the return to accept both varchar2 type and number type? sql oracle plsql rowtype share|improve this question edited Nov 17 '15 at 7:27 Lalit Kumar B 27k82547 asked Nov 17 '15 at 6:59 rob 134 3 the type of v_test that you return students%rowtype; conflicts with your return type of varchar2. In fact to accept the return you´d need to, change the return type to students%rowtype –Kevin Esche Nov 17 '15 at 7:01 students%rowtype is a type of one variable, what is the problem? –smnbbrv Nov 17 '15 at 7:06 nevermind fixed thanks guys –rob Nov 17 '15 at 7:09 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote accepted RETURN varchar2 You need to return the rowtype, but you are returning a scalar. VARCHAR2 cannot hold a row, it can hold only a string value. Modify it to: RETURN students%rowtype; Demo using standard EMP table: SQL> CREATE OR REPLACE FUNCTION studentName( 2 f_name IN VARCHAR2) 3 RETURN emp%rowtype 4 IS 5 v_test emp%row
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 3 Replies Latest reply on Dec 6, 2005 7:02 AM http://stackoverflow.com/questions/33750936/pl-sql-function-to-return-varchar2-numbers by sunilchoudhary ORA-06553: PLS-801: internal error [56319] sunilchoudhary Dec 2, 2005 12:24 PM Hi Folks, Trying to port my database from 32 bit to 64 bit while connection getting error as -------------- SQL*Plus: Release 9.2.0.1.0 - Production on Fri Dec 2 17:20:11 2005 Copyright (c) 1982, 2002, Oracle Corporation. All https://community.oracle.com/thread/346960 rights reserved. Enter password: ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-801: internal error [56319] -------------- Have tried running catalog.sql catproc.sql and utlrp.sql from sys before as well as after making systemtrigger_enabled=false in init.ora Still can not get across this issue.. Anyone .. having any insights pls .. enlighten. 33303Views Tags: none (add) This content has been marked as final. Show 3 replies 1. Re: ORA-06553: PLS-801: internal error [56319] sunilchoudhary Dec 5, 2005 4:59 AM (in response to sunilchoudhary) Any ideas.. Like Show 0 Likes(0) Actions 2. Re: ORA-06553: PLS-801: internal error [56319] A.D. Dec 5, 2005 9:25 AM (in response to sunilchoudhary) some times back I received the same message and after a great deal of R&D I landedup with the following solution.. execute dbms_stats.delete_database_stats Like Show 0 Likes(0) Actions 3. Re: ORA-06553: PLS-801: internal error [56319] sunilchoudhary Dec 6, 2005 7:02 AM (in response
case is not handled in version 11.1.0.6. I created a function which returns a ROWTYPE and when calling this function from a simple sql statement an http://www.cornbio.com/oracle-pls-801-internal-error-when-returnig-rowtype-in-select-clause/ internal error occurs. create table testing as select 1 id, 'A' val from dual Read more 2014-06-04 15:34 Oracle ERROR: ORA-06553: PLS-801: internal error [55018] Sorry for my bad english ... I got error ... ERROR: ORA-06553: PLS-801: internal error [55018] if I build function than return %rowtype like this SELECT * INTO var_return FROM ....... RETURN var_return Oracle 11g internal error in RedHat Linux Read more 2012-10-11 00:51 Oracle ORA-06553: PLS-801: internal error [56319] i have opened my rman backup, not it works. (X64) but when i need to drop a user, i got error below, SQL> drop user ugur; drop user ugur * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-801: internal error [5631 Read pls-801 internal error more 2015-04-25 01:38 Oracle getting ORA-06553: PLS-801: internal error [56319] on duplicate db. I have used rman duplicate script to create a duplicate of our production db.The production db is running on linux itanium 64 bit and the server where the duplicate db is runninng on linux x86 32 bit. Both servers are running the smae rdbms version w Read more 2013-11-16 22:52 Oracle ORA-06553: PLS-801: internal error [hshuid:LU invalid] DBA refreshed database B from database A (both 64-bit). Database C (also 64-bit) had a link to database B. DBA claims to have rebuilt the link from C to B, but queries now result in: SQL> select [emailprotected](12540, '200808', Read more 2013-03-02 10:30 ORA-06553: PLS-801: internal error [56319] I have the following errors when trying to use Oracle. Oracle is installed on Aix 4. Besides the errors I was able to create users, tablespaces ... The problem arrived when I tried to drop a user or a table (using the system user). Since I need to dr Read more 2012-07-14 01:49 Oracle PLS-00801: internal error [79704] Error I am using Ora