Re: Is it possible using stored procedure like this way???

1. Yes, I can call the procedure with SQL*Plus as user "test".
2. I don't understand the second step, because I don't know VB program and I' m newbie to ASP...Is there another way to test?
3. Instead of ODBC, you mean using OLE DB or OO4O or ??

Thank you for your help

Dodo

> You'll have to take a step back then and check the following:
>
> - can you call the procedure with SQL*Plus as user "test"? Perhaps the
> package is in another schema?
> - I would then put together a small VB test program (not VBScript or
> ASP, just a standard .EXE) and test database access with that. That way
> it's isolated and you can use the normal ADO object model, and not just
> plain old CreateObject.
>
> Have you considered switching drivers? Microsoft drivers for Oracle are
> pretty lame you know.
>
> -- Tom
Received on Wed Aug 04 2004 - 10:45:26 CDT