From the answers to calling a stored proc over a dblink it seems that it is not possible to call a stored procedure and get the ResultSet/RefCursor back if you are making the SP call across a remote D
Oracle Databa开发者_StackOverflowse 10g Release 10.2.0.3.0 - 64bit Production PL/SQL Release 10.2.0.3.0 - Production
So, I have this java based data trasformation / masking tool, which I wanted to test out on Oracle 10g. The good part with Oracle 10g is that you get a load of sample schemas with half a million recor
My question is quite similar to Restricting a LEFT JOIN, with a variation. Assuming I have a table SHOP and another table LOCATION. Location is a sort of child table of table SHOP, that开发者_如何学C
This might be simple but I am new to Oracle. I a开发者_如何学运维m using Oracle 10g and have a form that lists our information from a linked table in a tabular Layout. The last column of data is a \"l
I have two cursors in my procedure that only differ on the table name that they join to. The cursor that is used is determined by a parameter passed into the procedure
I am using the Oracle .NET Provider and am calling a stored procedure in a package. The message I get back is \"Wrong number or types in call\". I have ensured that the order in which the parameters a
Trying to insert 315K Gif files into an Or开发者_StackOverflow中文版acle 10g database.Everytime I get this error \"ora-01460: unimplemented or unreasonable conversion requested\" whe I run the stored
How t开发者_JS百科o create/refresh materialize view in oracle 10g.Oracle documentation hereCREATE:
Does anyone have experience with database links between 10g and 11g? Is this a开发者_如何学Go supported setup/operation? Is it possible? Are there any problems? Caveats?I\'ve been using DB Links from