Oracle and asp multiple sql statements

[Mike D]

I have a connection between asp and oracle. I have tried
the OLE DB connection from both MS and oracle.

I can connect and do 1 insert statement but how do I do 2?

Insert Into () values ();Insert Into () Values

gives me an "ORA-00911: invalid character" error. How do
I seperate the statements or will I have to hit the db
twice:-(

Thanks
Mike

[Turkbear]

On Fri, 11 Jun 2004 05:24:23 -0700, "Mike D" <anonymous@discussions.microsoft.com> wrote:

>I have a connection between asp and oracle. I have tried
>the OLE DB connection from both MS and oracle.
>
>I can connect and do 1 insert statement but how do I do 2?
>
>Insert Into () values ();Insert Into () Values
>
>gives me an "ORA-00911: invalid character" error. How do
>I seperate the statements or will I have to hit the db
>twice:-(
>
>Thanks
>Mike

Separate the statements and send them separately..

Sql1 = "Insert Into () values ()"
Sql2 = "Insert Into () values ()"

yourconn.Execute(Sql1)
yourconn.Execute(Sql2)

Same connection, just 2 statements....( the ' ; ' , when in SqlPlus will submit a statement, but not plain Sql )

[Mike D]

Thanks for the reply. I have been working on learning
this stuff. Thanks for posting the links in your last
reply to me. I finally have my first sp running from asp
so the multi-insert may not be necessary:-)

Thanks again

Mike

>-----Original Message-----
>On Fri, 11 Jun 2004 05:24:23 -0700, "Mike D"

<anonymous@discussions.microsoft.com> wrote:

>

>>I have a connection between asp and oracle. I have

tried

>>the OLE DB connection from both MS and oracle.
>>
>>I can connect and do 1 insert statement but how do I do

2?

>>
>>Insert Into () values ();Insert Into () Values
>>
>>gives me an "ORA-00911: invalid character" error. How

do

>>I seperate the statements or will I have to hit the db
>>twice:-(
>>
>>Thanks
>>Mike

>
>Separate the statements and send them separately..
>
>Sql1 = "Insert Into () values ()"
>Sql2 = "Insert Into () values ()"
>
>yourconn.Execute(Sql1)
>yourconn.Execute(Sql2)
>
>Same connection, just 2 statements....( the ' ; ' , when

in SqlPlus will submit a statement, but not plain Sql )

>
>.
>