Search results for query: *

am using http_util routines to call a web service, and in particularly UTL_HTTP.WRITE_RAW the value i am wanting to write is in a table as a BLOB, but obviously the write_raw wants it as a 'raw' how do i convert the blob to a raw thanks, andy

I am using http_util routines to call a web service, and in particularly UTL_HTTP.WRITE_RAW the value i am wanting to write is in a table as a BLOB, but obviously the write_raw wants it as a 'raw' how do i convert the blob to a raw thanks, andy

hi, is there a way to supress the parameter form? i aim to populate the paramters in the before report triggers, but i found it still popped up a default parameter form. is there something i can do to stop this?

hi, how can i stop reports from trying to produce a parameter form. i intend to populate the parameters from a before form trigger , but it still pops up a default parameter form with the values populated. is there anyway i can say 'don't produce a paramter form'?

hi, I have the following sceaio I want to write a query for, but can't think how to do it (assuming it is possible) (well, i've simplified here to get to the point I want) Imagin I have a 'rules' and a 'rule instruction' table as follows: rules ----- rule_code rule_description...

hi, i have a web page (generated from oracles application server) with a 'file' input box (ie. tag of '<input type="file">') The DAD is set up to put this in a table and call the procedure to process it. All this worked merrily until we started getting the latest office documents , of type...

hi , thanks for the responses everybody. Information i should have put in the first mesage...... 1) This is actually code called form a 'bean area' on an oracle form. Although that might sound like it complicates it, it really acts like an applet. 2) This worked fine in the development...

hi, i am tying to establish a connection to an oracle database with the following code: Class.forName("oracle.jdbc.driver.OracleDriver"); System.out.println ("Registered Oracle Driver"); con1 = DriverManager.getConnection ("jdbc:oracle:thin:@//"+connectionString,userName,password)...

No.... i do mean after *quering* the data.... so.... picture a master-detail form whith the detail block itself a multirow block. I want to perform an action after it has *completely* populated the lower block. ie. once it has queried back all the data. as i say - post query is the nearest i...

personally, i use toad mostly. But i have that for other reasons - its a nice database tool for all sorts of reasons.

well there's the sys table 'all_constraints' which you can query. or as above post suggests, the 'TOAD' application has some nice tabs on on the schema browser when viewing a table - one for contrainsts and the other general references (shows both parent and child tables) Oracle designer...

hi, i want to trigger something to happen in a multirow block *after* it has finished querying back *all* the records. now a post-query fires after *each* row - i want something to fire after *all* rows have been queried. anybody any thoughts? thanks, andy

ummm..... there's ratehr alot of triggers.... any particular you are interested in? or anythign you are trying to do that you want a trigger for?

hi, i want to trigger something to happen in a multirow block *after* it has finished querying back all the records. now a post-query fires after *each* row - i want soemthing to fire after *all* rows have been queried. anybody any thoughts? thanks, andy

hi, i'm trying to copy the content of a clob to a *local* file. I can do the getting the text out of the clob and writing to the screen (then using a spool file to write to a file).........providing the clob is small enough. of course, if the clob is too large then it blows the buffer. I...

is it possible to use a com object from java?

hi, i am creatign a JFileChooser dialog to alow the user to select a file, but the details/list buttons at the top right seem to be greyed out and it only seems to display in the 'list' mode. How can i get it to enable/respond to the 'details' button such that it desplays the fiel details...

thanks - i am actually using an oracle database.

hi, i'm wanting to construct a clob (from various pieces of information) and save to a database. now, i have managed to write a clob value to the database using the 'setClob' in an 'prepared statement' update statment. however, i am struggeling to create a clob in the first case to write out...

I have a web page that runs an applet usinght <OBJECT> tag. I'm trying to make it use a specific version of of the plug in so am using the 'classid' of : "clsid:CAFEEFAC-0014-0002-0015-ABCDEFFEDCBA" which i unserstood to force it use specifically 1.4.2_15 plug in. however, it seems to just...