Re: Temp tables again

["Davis, Rob" <rdavis@CAR-SPA.COM>]

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