| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re:Problem with DYNAMIC SQL
Hi,
Do u have the privleges granted directly to you ???
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019
-----Original Message-----
Sent: Thursday, December 06, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Hi,
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
> >
>
-- 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: Ganesh Raja INET: ganesh_at_gtfs-gulf.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 - 01:42:13 CST
 |
 |