Re: Re:Problem with DYNAMIC SQL

From: ehsan sinavalda <ehsanoracle_at_yahoo.com>
Date: Wed, 05 Dec 2001 22:58:32 -0800
Message-ID: <F001.003D661D.20011205224018@fatcity.com>

Hi,

• Nikunj Gupta <good_dba_at_hotmail.com> wrote:
  > Hi,
  > Assign CREATE TABLE statement to a variable and then
  > issue
  >
  > EXEC SQL EXECUTE IMMEDIATE <Variable>
  >
  > This should work
  

I have tried it before sending the mail, and I tried it after receiving your mail but I did not work and it had the same problem

Thanx
E.

> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, December 05, 2001 06:30 AM
>
>
> > Ehsan,
> >
> > I don't think so. In the case you've listed
> the better way would be
> to do:
> >
> > EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4));
> >
> > The use of EXECUTE IMMEDIATE is more suited to
> statements that are
> being
> > dynamically created on the fly. This one is not.
> >
> > Dick Goulet
> > Pro*C Evangelist
> >
> > ____________________Reply
> Separator____________________
> > Author: ehsan sinavalda <ehsanoracle_at_yahoo.com>
> > Date: 12/5/2001 5:05 AM
> >
> > Hello
> >
> > As I found in proc docs the following statement
> should
> > work properly:
> >
> > EXEC SQL EXECUTE IMMEDIATE
> > "CREATE TABLE dyn1 (col1 VARCHAR2(4))";
> >
> > But when I want to compile a PROC prog. that has
> the
> > above stmt in a function I recevive the following
> > compile error:
> >
> > sample1.cc: In function `void test()':
> > sample1.cc:1313: break statement not within loop
> or
> > switch
> >
> > Could someone pls help me resolving this problem?
> >
> > Thanks
> >
> > E.
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Buy the perfect holiday gifts at Yahoo! Shopping.
> > http://shopping.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: ehsan sinavalda
> > INET: ehsanoracle_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >

>

---

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author:
> > INET: dgoulet_at_vicr.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >

>

---

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Nikunj Gupta
> INET: good_dba_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

---

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).

---

Do You Yahoo!?
Send your FREE holiday greetings online! http://greetings.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ehsan sinavalda
  INET: ehsanoracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Dec 06 2001 - 00:58:32 CST