Home » SQL & PL/SQL » SQL & PL/SQL » sqlerrm,sqlcode (oracle - 9i)
sqlerrm,sqlcode [message #316803] Mon, 28 April 2008 07:04 Go to next message
venki.august27
Messages: 3
Registered: April 2008
Location: vijayawada
Junior Member
Sir,

Any one can help me out in getting oracle message when i give
any relevant code to any variable.

Eversince i am trying out this example but not getting.

create or replace function oracode(sqlc number)
return varchar2
is
sqlc number;
sqlm varchar2;
begin
select sqlerrm into sqlm from dual;
end;

i am not getting when i give code and actually code is not running.


Thank & regards
venki
Re: sqlerrm,sqlcode [message #316813 is a reply to message #316803] Mon, 28 April 2008 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This is NOT an expert question.

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them including what is said about formatting.

As you are an expert, I don't answer the question because you obviously already knows it.

Regards
Michel

[Updated on: Mon, 28 April 2008 07:37]

Report message to a moderator

Re: sqlerrm,sqlcode [message #316818 is a reply to message #316803] Mon, 28 April 2008 08:01 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
venki.august27 wrote on Mon, 28 April 2008 08:04

Any one can help me out in getting oracle message when i give
any relevant code to any variable.

Eversince i am trying out this example but not getting.

i am not getting when i give code and actually code is not running.


???

What is giving relevant code to a variable mean?
What does "Eversince i am trying out this example but not getting" mean? What are you not getting?
"i am not getting when i give code" means what? What are you not getting?
Re: sqlerrm,sqlcode [message #316850 is a reply to message #316803] Mon, 28 April 2008 10:05 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA
Senior Member
You don't know how to create a proper function or even post a proper question and your biography says that you are working as an Oracle instructor. For the sake of your students, you should resign.
Re: sqlerrm,sqlcode [message #316852 is a reply to message #316850] Mon, 28 April 2008 10:09 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
your biography says that you are working as an Oracle instructor.

Ouch! I can't believe it... Good grief! sigh Sad

Regards
Michel
Previous Topic: Select job, empno from scott.emp but distinct job ?
Next Topic: cursor to table in anonymous block
Goto Forum:
  


Current Time: Mon Feb 17 22:25:53 CST 2025