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

With your method, I got the error message:

[Microsoft][ODBC driver for Oracle]Syntax error or illegal access

Error message is in Chinese, that's my translation. I don't know why it says illegal access. Thus I think perhaps it's impossible
to use this syntax {Call PkgPartition.add(?)} where this procedure calls another
function ....

Thanks a lot for your help, I'll try OO4O. Since I never use it, I wonder if I need to install some component before use it???

Dodo

> I would definitely use OO4O, if I were you. Don't know what else to tell
> you, since the error message doesn't give any clues. You can try
> printing out the error stack after you Execute()
>
> on error resume next
> Comm.Execute
> if err then
> for i = 1 to Con.Errors.Count
> Response.Write(Con.Errors(i).Description+"<BR>")
> next
> end if
>
>
> Maybe that will tell you more.
>
> -- Tom
Received on Wed Aug 04 2004 - 12:15:43 CDT