Through Oracle queries is it possible to find out which views/synonyms/tables a stored procedure use? In PL/SQL Developer if you collapse out a stored procedure it will show "References" which shows all the tables/views/synonyms that the stored procedure uses. I am trying to implement this functionality into a script which will com...
My project requires me to use OC4J and Oracle Database system. Therefore, I go to Oracle web page to download OC4J Application Server (oc4j_extended_101350) and Oracle Database 10g. Installation of OC4J is simple. I just unzip it to a folder and set the JAVA_HOME and ORACLE_HOME. Then everything is fine. But then, Oracle Database canno...
Friends, This Ask Tom thread which I found via another SO question, mentions Table and Transactional API's and I'm trying to understand the difference between them. A Table API (TAPI) is where there is no access to the underlying tables and there are "getters" & "setters" to obtain information. For example to select an address I ...
I'm trying to add an attribute to an already existing Object Type in an Oracle 10.2.0.4 DB. The schema is valid, and everything is working before running the following statement: ALTER TYPE sometype ADD ATTRIBUTE (somefield varchar(14)) CASCADE INCLUDING TABLE DATA / SHOW ERRORS The alter fails with an ORA-22324 and an ORA-21700. Afte...
Does a Join table (association table) have a primary key ? many to many relationship. I've seen some Join tables with a primary key and some without can someone please explain when you would have a primary key in a join table and why? Thank you in advance;-) ...
What is the best way to store Binary data (images, pdf's, mp3's, videos ect) in mysql and why? What i would love to know is how you do it(as developers) and why? Also how the big sites do it? Thank you in advance ;-) ...
TYPE point IS RECORD ( X NUMBER, -- The X co-ordinate of the point Y NUMBER -- The Y co-ordingate of the point ); This is defined in my package header. It is then used in a procedure defined in the same package. Is it possible for me to call the procedure via ODP.net? ...
Hi all, Trying to get ordinary least squares regression going using the UTL_NLA package in Oracle. The UTL_NLA package is installed by default and appears to be working. Next up, I tried to run some of the regression sample code (OLS_Regression) that ships with Oracle (olsexmpl.sql and olstype.sql). I am able to create the model just ...
Can someone advise on why I get errors opening the file in the code below. The errors start about half way through the 9th iteration of 25 threads, and are "Too many open files" errors. The error only happens when running in threads, and only when the DBI connect/disconnect are used. This shouldn't affect the open file count at all shou...
Hi folks, In my production environment, my front end is on a.example.com and my back end is on b.example.com: I'm creating a cookie in .example.com domain in path '/' using javascript for it to be read from any subdomain. When I try to read the cookie from b.example.com domain from Oracle using owa_cookie it gives the error no_data_fo...
Is there any tool that would help to move/translate appliaction written in oracle forms6 to .net ? maybe not whole application at once, but maybe modules/forms(screens) to windows forms. I know that languages are different (pl/sql vs .net) but maybe that tool could make some template and programmer would be responsible to translate busin...
hello all, i'm working in a kofax application connected with oracle database. i found an error as ERROR markview.viewer.MvViewer org.springframework.remoting.RemoteAccessException: Could not access HTTP invoker remote service at [ias9:opmn:ormi://uhmvtst.uhhs.com:6003:markview_tst4/mvas/remote/EnterpriseService]; nested exception is ...
I have PHP code that execute a stored procedure 10 times. If one stored procedure call fails, it should continue on, and at the end commit the transaction. It basically looks like this: $connection = getConn(); foreach($row as $i=>$j) { $SQL = "BEGIN MYPROC.EXECUTE(:VAL1, :VAL2); END;"; $statement = OCIParse($connection, $SQL); ...
I'm trying to make an in statement with values coming from DB and then use them in another query. DB is Oracle Example: I've been beating my head around this for quite some time now. I need some help: Groovy Code: def myList = [] def myQuery = "select USER_ID from USER_TABLE where rownum < 3" println myQuery sql_dw.eachRow(myQuery) {...
The company where I work let me choose the IDE to work with Oracle. I may choose betwwen SQL Developper Toad PL/SQL Developper What are the advantages and disavantages of each one ? The price is not a concern. Licenses are already paid... ...
Please note: I am asking the question I want answered. I know this question means the database is set up poorly. So I will vote down any questions that suggest changing the way the table is set up. I need to duplicate a bunch of rows, while changing one value. name col1 col2 dave a nil sue b nil sam c 5 needs t...
We are using MS Access as a reporting front-end for Oracle. The data is accessed via an ODBC connection, and there are two linked tables in Access to Oracle that are the raw data tables. I'd like to be able to set up the connection and link the tables from within the Access file. That way users don't have to worry about setting up an DSN...
I have an ETL that is importing tables from Oracle to SQL 2008 using the OLEDB FastLoad. The data in Oracle is non-unicode. When the table is created in SQL it is created with unicode datatypes. For some reason the datatypes are being forced from non-unicode to unicode. Do any of you know of a way to stop this from happening? Possibly a ...
Possible Duplicate: Oracle Multiple update Query I have a query Select item_code,comp_code from item; which returns item_code, comp_code 912001 01 912001 04 912002 01 912002 02 912002 03 912003 01 and i have three values for comp_code for each item. suppose comp_1...
Is it possible to correctly pass an OracleParameter to a boolean parameter in a pl/sql stored procedure? ...