Hi
Can anyone please tell me ,what is the alternative statement ,For the particular statement used in Oracle
'set serveroutput off'.
The idea is if there is number of print statements being used in procedures, then the messages should not be displayed when the procedure is executed...
Suppose I declare a variable with varchar(6000)
In my table i have a field with the datatype as text.
If I try to insert the value of the variable into that variable either directly or using
convert the value for the string gets truncated.
Is there any way to resolve this.
Thanks in advance
The exception handling in oracle is different from the way it is done in sql-server.
If we need to trap errors in sql - server we use @@error,
The problem with this method is that after each statement we have to explictly mention the condition.
In oracle at the end of the pl/sql block we use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.