Re: Desperate call for help

I'm not sure how personal Oracle/Access work, but the general ODBC syntax is as follows:
(this is a snippet from my VFP code)..
'annyddl' is my stored procedure in oracle which creates a table in Oracle.

Sql_Str = "CREATE TABLE " + cTableName + cTableSpace + " storage "

        Sql_Str = Sql_Str + "(initial " + cInitialSize + " next " + cNextSize + " minextents " + cMinextents

	Sql_Str = Sql_Str + " maxextents " + cMaxExtents + ") " 
	Sql_Str = Sql_Str + " As SELECT EMP_NAME, EMP_NO FROM EMP " 
	

Exec_Str ="{call anyddl(" + "'" + Sql_Str +"'" + ")}"

ReturnVal = SQLEXEC(nHandle,Exec_Str)

Hope this helps..

Hrishikesh Samant

Marino Simons wrote:
>
> Hi,
>
> I am still having difficulties calling a stored procedure on a oracle
> database.
> I have on an Personal Oracle for windows 95, a very simple stored procedure
> (it needs not input variables and it returns no rows), but I can't execute
> it from within access 95.
> I always receive an error message from the oracle database: invalid
> statement.
> Does someone know how i have to call the stored procedure within access. I
> know I have to use a passthrough query, and I do kwon that the EXECUTE and
> CALL statement don't work.
>
> Thanks in advance,
> Marino
>
> E-mail:marino_at_club.innet.be
Received on Mon Apr 14 1997 - 00:00:00 CDT