sqlerrm,sqlcode [message #316803] |
Mon, 28 April 2008 07:04  |
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 #316818 is a reply to message #316803] |
Mon, 28 April 2008 08:01   |
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?
|
|
|
|
|