The STRING_TAB table has the following structure:
View the Exhibit and examine the code.
What is the outcome on execution?
A.
It displays
Out put buffer not long enough.
This is my test string.-.
B.
It displays only
Output buffer not long enough, and exits the anonymous block.
C.
It displays only
This is my test string. – Because EXCEPTION should have been defined in the anonymous block to get the error message.
D.
It does not display any of the MEMS_PUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section of a procedure.
A is correct
Yep, A is correct.
A
A is the right answer
heres the code run and verify it..
declare
in_string varchar2(25) := ‘this is my test string’;
out_string varchar2(25);
procedure double (original in varchar2,new_string out varchar2) is
begin
new_string := original|| ‘+’ || original;
exception when value_error then
dbms_output.put_line(‘output buffer not so long’);
commit;
end;
begin
double (in_string,out_string);
dbms_output.put_line(in_string||’-‘||out_string);
end;
PL/SQL procedure successfully completed.
Output :-output buffer not so long
this is my test string-
further queries contact [email protected]
thank you.
Lectura a través de la buena contenido , se ayuda Me para completar para de tiempo en tiempo.
http://www.opinionesdating.com/meetic-opiniones/
we like to honor numerous other internet websites on the web, even if they arent linked to us, by linking to them. Below are some webpages worth checking out
Here is a great Weblog You might Discover Interesting that we Encourage You
Every the moment in a although we select blogs that we read. Listed beneath would be the latest web-sites that we select
The information and facts mentioned in the article are a few of the best available
Sites of interest we’ve a link to
Please check out the websites we stick to, such as this 1, because it represents our picks in the web.
Check beneath, are some completely unrelated web-sites to ours, even so, they may be most trustworthy sources that we use.
Very handful of sites that transpire to be comprehensive below, from our point of view are undoubtedly well really worth checking out.
Every as soon as in a when we pick blogs that we study. Listed beneath are the latest internet sites that we pick out
Sites of interest we’ve a link to.
we prefer to honor quite a few other world-wide-web websites on the internet, even if they arent linked to us, by linking to them. Beneath are some webpages worth checking out
check beneath, are some completely unrelated web-sites to ours, having said that, they may be most trustworthy sources that we use
below you will uncover the link to some internet sites that we consider you must visit
check beneath, are some completely unrelated sites to ours, nonetheless, they may be most trustworthy sources that we use
we prefer to honor several other world-wide-web web pages around the internet, even though they arent linked to us, by linking to them. Beneath are some webpages really worth checking out
very handful of sites that transpire to become comprehensive beneath, from our point of view are undoubtedly very well worth checking out
Sites of interest we have a link to.
Check beneath, are some absolutely unrelated internet websites to ours, on the other hand, they may be most trustworthy sources that we use.
the time to study or visit the content material or web sites we’ve linked to beneath the
below you will locate the link to some sites that we assume you should visit
please visit the sites we stick to, such as this 1, as it represents our picks in the web
we like to honor a lot of other web web sites on the web, even though they arent linked to us, by linking to them. Under are some webpages really worth checking out
Very neat article post.Much thanks again. Will read on…
http://corporategifts.tblogz.com/
I cannot thank you enough for the article.Thanks Again. Really Cool.
http://www.farmandhomegmac.com
I value the post. Much obliged.
Very neat blog article.Really thank you! Keep writing.