check this lines: ' here you are adding a parameter type number, and your variable name it's strHRNum (type string ?) OraDatabase.Parameters.Add "strHRNum",...
Hi! We have this ASP application that connects to an Oracle server using OO4O. During testing all was well, but when we released this on the live server, it...
can you display the sentence SqlQuery before/after the line DataFields=OraDatabase.CreateDynaset(SqlQuery,0) ??? try this: Response.Write SqlQuery Response.End...
Hi, Using oraOLEDB.Oracle.1 oledb provider I am able to return multiple recordsets from a stored procedure. I'm considering using OO4O, will I still be able...
Using OO4O to access Oracle database through VB, it has database object pooling mechanism. And I understand that there is single connection to database using...
Can you send some example for return multiple recordsets from a stored procedure. with oraOLEDB.Oracle.1 oledb provider Please? ... multiple ... how)?...
Hi Mak again, Callback::Notify is not getting called at all? trying your solution ... Mak ... etc.. ... them ... with ... name. ... it´s ... NotifyMe ... ...
Hello: I'm trying to return a value from a LONG datatype file. I have included a sample below. The error message that I get is OIP-04131: Field processing...
Hi, Sorry for the late response. But I can get the SQL query after that point and that query is also ok . I can execute it in SQL plus. -- Asim ... it for ... ...
can you send the sentence ? pls send the string query result. gbaltazar From: "anuragag_iitk" <anuragag_iitk@...> Reply-To: oo4ole@yahoogroups.com To:...
When I switch from ODBC to OO4O, one thing I can't manage is to get return value from a function by parameters (stored procedure is fine). OO4O provides ...
I would greatly appreciate any and all help the membership of this group can provide. I have a VB6 app that uses OO4O to connect to our Oracle database. I...
Hello to all my Oracle friends. I would like to help you all just by selling you the selftest softwares for the Oracle 8i DBA track only for $99. The original...
We actually got around this by passing in a parameter called "return_code" as an out parameter. - Glen ... return value ... provides ... sample code....
Hi I'm having difficulty selecting the required data from two tables either with a sql statement or PL/SQL. I was wondering if anyone could help. The data...
Works great. Thanks!
One problem though - I also need all rows from the item table (where the
'itemstatus' is 'active' and the 'expirationDate' is greater...
mabe a book on sql would go a long way...... may i suggest the O'Reilly scorpion book. maybe then everyone on this list doesn't get all these sql how-tos ... ...
eric.mccraw@...
Apr 30, 2002 4:26 pm
1360
Sorry if I cluttered your inbox. I'm a student learning SQL and PL/SQL.
I have some books but didn't know where to look.
-----Original Message-----
From:...
OK, A member of the group recommended that I move my On Error statement to the beginning of the subroutine. No joy. same result. The exception propogates...
Tell me please why i encounter ora 3113 End of comunication... the error at the first DB.execute, when I call a stored procedure with 23 parameters, IN , OUT<...
If you're developing within the VB IDE, make sure your error-handling options are set correctly. Tools -> Options -> General [a tab] -> Error Trapping [a...
Kudos to you, Sam. I had a feeling that there was something about the environment that would resolve my obstacle. Your recommendation has made me a happy...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
