I am getting the following error: SQL execution error, ORA-00905: missing keyword Code: sql = "SELECT cola, colb from DB1 FOR UPDATE WHERE Cola = 'abc'" ...
Hugh.Guilbeau@...
May 1, 2001 9:39 pm
1095
IIRC, you cannot use the SELECT... FOR UPDATE syntax together with the dynaset edit/update methods. Tim Romano ... From: <Hugh.Guilbeau@...> To:...
Tim Romano
tim@...
May 2, 2001 1:06 am
1096
Hi all, I hope i'm not too far off topic here but can anyone answer me this: Precompile step in code I no nothing about. /oracle/product/8.0.5bin/proc code=cpp...
mgcornick@...
May 2, 2001 8:12 pm
1097
Hello, I have the following problem using oo4o 8.1.7.3.12 with VC++ 6.0: I can detect a disconnection but I cannot reconnect to the server. There is no problem...
Roberto de Paiva
rpaiva@...
May 2, 2001 10:29 pm
1098
Thanks for the suggestion, but the examples in what little documentation there is for 0040 show "select ... for update ...". When I take out the "for update" I...
Hugh.Guilbeau@...
May 3, 2001 12:16 am
1099
Hugh, Here's what I have in my oo4o help file: "Normally, when a dynaset is created, rows are not locked in the database until Edit is invoked. If this is not...
Tim Romano
tim@...
May 3, 2001 2:47 am
1100
Your installation is probably broken in one of two ways: 1)You do not have the correct version of the oracle client installed from that version of Pro*C or it...
Mark Tomlinson
marktoml@...
May 3, 2001 3:20 am
1101
Doesn't the FOR UPDATE clause need to go after the WHERE clause? ... __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy...
c shay
cshay@...
May 3, 2001 7:11 am
1102
Where can I get a description of the methods of the oradc with VC++ ? How can I use the wrapper-classes? Thanks!...
Peter Burucker
pburucker@...
May 3, 2001 11:52 am
1103
I finally figured this out, and I think that it is a bug. When I do the select with column names (particularly a date), it will not work. If I code select * it...
Hugh.Guilbeau@...
May 3, 2001 10:39 pm
1104
hi 0040 folks i'm trying to call the stored PL/SQL function below, grab the boolean result into an Excel VBA variable with no luck. I could find no examples of...
dalemotsiff@...
May 7, 2001 3:36 am
1105
Hi We have tried this also but to no avail (Not sure if possible ?) We have however found a work around though, this bascially uses an extra parameter for...
padraicmulligan@...
May 8, 2001 12:03 pm
1106
interesting solution. if i understand you correctly, you no longer write PL/SQL "functions" which return a single value, but now your code returns "out"...
dalemotsiff@...
May 9, 2001 4:12 pm
1107
Hi Guys, Does anyone knows if the oipsr** files created by oo4o on my tempdir can causes crashes on my application? The environment I am using is VC++ and...
Roberto de Paiva
rpaiva@...
May 9, 2001 8:41 pm
1108
Hi, i have a problem with inserting big number of rows from an VB Application into Oracle. In the pas i used a 16-bit VB Application in conjunction with Oracle...
Stefan.Waldschmitt@...
May 10, 2001 7:36 am
1109
Dale Here is the answer taken from URL http://technet.oracle.com/doc/oracle8i_816/nt.816/a99998/o4o00321.htm Sample function is found in O4OO Pack 'Execute the...
padraicmulligan@...
May 10, 2001 1:49 pm
1110
Guys I am using Executesql and am having some untraceable speed problems. When I use OO4O or ADO to execute simply SQL queries speed is very good and compable...
padraicmulligan@...
May 10, 2001 2:19 pm
1111
When you run the code in sqlplus you already have a session open, but I notice in VB you are opening a new session which than has to connect to the database...
Griffiths, Stewart
stewart.griffiths@...
May 10, 2001 2:37 pm
1112
Dale I'm not working with PL/SQL functions but with packaged procedures, but the solution I'm using for the BOOLEAN parameters can be applied to function...
Guido Schmutz
guido.schmutz@...
May 10, 2001 2:54 pm
1113
Griff In the example I have created I have removed all the connection pooling that is used (This application runs under MTS) But I am allowing of the extra...
padraicmulligan@...
May 10, 2001 3:51 pm
1114
thanks Guido. I haven't had a chance to fiddle with the code for a function, but you're right, that looks like it should work for me fine. also, thanks for...
dalemotsiff@...
May 11, 2001 4:40 pm
1115
Hi Dale Yes, I'm using my own generator to generate 100% of the necessary code to access PL/SQL procedures from VB via OO4O. Originally the generator was build...
Guido Schmutz
guido.schmutz@...
May 14, 2001 4:20 pm
1116
that's some beautiful work Guido! now you've opened my eyes to whole new slew of questions about auto-coding from the data dictionary. immediately after...
dalemotsiff@...
May 14, 2001 9:21 pm
1117
Dale Yes, that's more or less what I'm doing as well. The manual shows the following description for these two columns SEQUENCE Argument sequence, including...
Guido Schmutz
guido.schmutz@...
May 15, 2001 5:21 pm
1118
I would like to use OBlob without dynaset but I've not found any example OBlob blob; blob.Write((unsigned char *)"1234567890", 10); ... ...ExecuteSQL("insert...
nesquikfrfr@...
May 16, 2001 3:34 pm
1119
Hi Creating a OBlob on the client-side and write to it is only possible, if you are using the latest version of OO4O (8.1.7.3.12). In this version on the...
Guido Schmutz
guido.schmutz@...
May 16, 2001 3:57 pm
1120
... possible, ... My db is 8.1.6. Can I use this version of OO4O with it ? ... In fact, I have to insert into my db a big amount of blobs So, I'd like to use...
nesquikfrfr@...
May 16, 2001 4:26 pm
1121
... Yes, I'm using the same configuration and it works fine. ... That should be possible. I've never used array binding with lob- datatypes, but the...
Guido Schmutz
guido.schmutz@...
May 16, 2001 5:37 pm
1122
can i use a bind variable in this situation: strSQL = "select distinct col1 from table1 where col2 like '%:bound_variable%'" i tried it, but oracle seems to...
Louie_Medina@...
May 16, 2001 5:46 pm
1123
Hi There two possiblities to achieve this: Either you put the % characters into the the value of the bind-variable itself, e.g. value_of_bind_variable =...
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.
