Re: Temp tables again

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

Rob,

One more thing u might have to do is :

take out semi-colon at the end of Create Statement
in Begin-SQL.

I know for sure, I have to do that with Informix,So
it should be same for Oracle too for SQR.

Manoj


>O.K.  I'm a bone head.
>
>Forgot the 'end-sql'
>
>Sorry gang.
>
>-----Original Message-----
>From: Davis, Rob
>Sent: Friday, October 22, 1999 5:29 PM
>To: 'SQR-USERS@list.iex.net'
>Subject: Temp tables again
>
>
>I was going to use an array, but since I have to get same data multiple
>time
>in the program, I thought I'd try the temp table approach that I saw here
>earlier.
>
>In Oracle 8.0.5, sqr 4.3.1 (I think).  Sticking with the basics I tried
>this:
>
>begin-sql
>
>CREATE TABLE ##"SYSADM".BILLING_RATES
>         (PLAN VARCHAR2(10) NULL, COVRG_CD VARCHAR2(10) NULL, RATE NUMBER
>NULL);
>
>end-procedure
>
>When I run the above I get the following:
>
>(SQR 1302) SQL buffer too small; use -Mfile to increase SQLSIZE.
>
>What is -Mfile and is there anything else I am missing?
>
>Thanks in advance,
>Rob

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com