Recent content by listener22

Forms are discussed in Oracle: Enterprise Developer Suite, but that's usually a pretty quiet forum. Jim oracle, vb

Right before the execute statement, put in msgbox that displays SQL, and see if you can spot an error in the string. Also check if SQL is reserved. Jim oracle, vb

Isn't it just len(the_string)? Jim oracle, vb

OK, forget my first suggestion. The error message seems to be indicating that "Test" is read only. Can you verify that? Can you write a short routine that opens up Test, reads it, and attempts to update it? Use debug and highlight the various variables to see their values, if...

if all else fails, find code for a daemon that will listen for commands via a pipe. You can find code like that on the internet, or in oracle's book on your version of oracle. In the stored procedure, pipe the command to the daemon, which will execute it. Well, in unix it's called a daemon, in...

Try moving the addnew outside of the Do section, so that it is a stand-alone command. Jim oracle, vb

try sys.dba_tab_columns Jim oracle, vb

try host Jim oracle, vb

Although in an insert method, order by is not needed... Jim oracle, vb

Which line in the module does debug highlight? Jim oracle, vb

I don't remember for sure, but don't you have to provide a break or some such statement to keep the case statement from continuing on to to the next choice? Jim oracle, vb

Note that depending upon your sequence buffer setting, among others, that you may experience some gaps in your sequence(s). The buffer gets some number of sequences, say 10 or 20, but if they're not used in some period of time, the remaining are tossed and the sequence starts again at a higher...

Isn't there a way to convert a long to a varchar2, assuming the long isn't over 32k or whatever the current limit is? You could then convert the varchar2 to a number. Jim oracle, vb

There's a book something like XML and Oracle that shows how to generate XML using Oracle commands. I'll take a look at the title tonight if you can't locate it. Jim oracle, vb

is your exe multi-thread? Jim oracle, vb