Home » SQL & PL/SQL » SQL & PL/SQL » Will the code be executed ???
Will the code be executed ??? [message #253938] Wed, 25 July 2007 06:03 Go to next message
kumarn
Messages: 13
Registered: June 2007
Location: London
Junior Member
Hi,


CREATE OR REPLACE PROCEDURE proc1
AS
v_flag VARCHAR2(1):='Y';
BEGIN
IF v_flag != 'Y' THEN
-- call another proc ---
proc2;  
END IF;  

END proc1;

CREATE OR REPLACE PROCEDURE proc2
AS
v_address VARCHAR2(35):= owa_util.GET_CGI_ENV('REMOTE_ADDR');
BEGIN
--update table ---
update USER_ADD set address = v_address;   

END proc2;


if I execute proc1, will owa_util.GET_CGI_ENV('REMOTE_ADDR')
be executed?





Re: Will the code be executed ??? [message #253941 is a reply to message #253938] Wed, 25 July 2007 06:14 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Is this a test? are you trying to see who knows? Obviously you have tried this yourself, so why are you asking us? And if you haven't tried it, why not.

Re: Will the code be executed ??? [message #253954 is a reply to message #253941] Wed, 25 July 2007 06:31 Go to previous messageGo to next message
kumarn
Messages: 13
Registered: June 2007
Location: London
Junior Member
Hi pabolee,

I have not tried it as currently I have no access to Oracle.

One of my friend asked this question and since I am not sure, I thought to put this in this forum.

Surely my intention was not to test anyone's knowledge. I have posted many queries before and I got satisfactory answers.

And if you know the answer instead of typing ~ 35 words, one letter Y/N was enough.

Thanks
Kumarn
Re: Will the code be executed ??? [message #253961 is a reply to message #253954] Wed, 25 July 2007 06:39 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
N
(Homework assignment?)

[Updated on: Wed, 25 July 2007 06:40]

Report message to a moderator

Re: Will the code be executed ??? [message #253967 is a reply to message #253954] Wed, 25 July 2007 07:05 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
kumarn wrote on Wed, 25 July 2007 13:31
Hi pabolee,

I have not tried it as currently I have no access to Oracle.
Oracle XE is a download of about 200MB and it is freely available.

kumarn wrote on Wed, 25 July 2007 13:31
And if you know the answer instead of typing ~ 35 words, one letter Y/N was enough.
I have to agree with paboblee: we're not here to function as your sandbox test environment.

MHE

[Updated on: Wed, 25 July 2007 07:05]

Report message to a moderator

Re: Will the code be executed ??? [message #253974 is a reply to message #253967] Wed, 25 July 2007 07:14 Go to previous message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
And it was 31 words Very Happy
Previous Topic: condition in triggers
Next Topic: can we write function with variable number of argument
Goto Forum:
  


Current Time: Thu Dec 08 14:12:27 CST 2016

Total time taken to generate the page: 0.15407 seconds