Suppose that I have 2 packages : A and B. In package A, I call a procedure in package B. In procedure of packcage B, is it possible to know that procedure has been called from package A ? Thank you very much for these informations. It was very instructive. I appreciate. ...
I'm working on a project where we will be connecting to a Oracle webservice using .NET (c#). The only thing is that we will build our client from our office location, but our customer will not give us remote access to their web service (company policy, etc). So our solution was to visit our customer on-site and 'clone' their webservice ...
Is using a VARCHAR2 (1 BYTE) any less efficient than using CHAR(1 BYTE)? Is using a VARCHAR2 (2000 BYTE) any less efficient than using CHAR(1 BYTE), if I never put any value longer than one character in the field? ** By efficient, I meant efficient in both time (searching) and space (storing). ...
Should I use for a web application Postgres or Oracle XE and why? They are both available for free and for use commercially. Why should I use one database over the other? ...
I have a table with an oracle date column when I do a select on sqlplus on the column it gives me the value like this 10-JAN-2007 Is this the precision of date in an Oracle column i,e does it not have hour sec, millisec in the date column. How can I map this to a java timestamp and get seconds since epoch. ...
Hi I have Computer A , IP = 10.20.30.40 (that store the Oracle Database) Data Source = ORCL , User = sa , Password = sa I have Computer B , IP = 10.20.30.44 (with this computer i want to connet) How I can Connect from Computer B - to - Computer A ? What is the Connection string that I need ? Thenk's for any Help ...
Whether there is an alternative of shift operators in PL/SQL? There is bitand function, but it accepts only *binary_integer*-type arguments. What should i do if i need check up lower/higher bit of really long number (probably set in the line)? In C there are << and >> operators. How I can realise them in PL/SQL? ...
Hi, Currently tasked with migrating Informix ESQLC files to Oracle Pro*C and have a few questions. First, we use a lot of proprietary Informix functions within our embedded ESQLC code such as: rstrdate( ), rtoday( ), rjulmdy( ), etc. Any pointers on how to convert these in Oracle Pro*C? Another thing I'm struggling with understanding ...
I have a legacy database with an integer set as a primary key. It was initially managed manually, but since we are wanting to move to django, the admin tool seemed to be the right place to start. I created the model and am trying to set the primary key to be an autofield. It doesn't seem to be remembering the old id in updates, and it do...
When did oracle start supporting "top": select top ? p2_.PRODUCT_ID from PRODUCT? ...
I am currently working on 9.2.0.8 Oracle database.I Have some questions related to Performace of Database that too related to Redo logs latches & contention. Answers from real practice will be highly appreciated. please help. My data is currently having 25 redo log files with 2 members in each file. Each member is of size 100m. So Is ...
I have a very unusual situation that I am hoping someone will be able to shed some light onto. My understanding of an oracle synonym is that it is basically an alias to a table in another schema. When I do a count from the synonym, it returns zero rows. When I do the same from the underlying table, it returns 12 thousand rows. I cannot...
I'm working on re-compiling some proC code that no one currently at my company has ever compiled. . . It's compiling OK, but when I copy it to the production server and run it I'm getting Oracle error ORA-12547 (TNS: lost contact) Any ideas? ...
I'm trying to connect to an Oracle 10g database using the built in Microsoft ODBC for Oracle driver. I want to use an dnsless connection, so I grab my connection string from www.connectionstrings.com. Ideally I won't have to setup a DNS entry or an Oracle TNS entry, and I may be mistaken, but I thought the above would do that for me. ...
Hi curtisk/all, I have an issue: when i issue this function below ti gives me the following error: select 'EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'''||name||'''||,OPTIONS=>DBMS_LOGMNR.NEW);' from v\$archived_log where name is not null; select 'EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'''||name||'''||,OPTIONS=>DBMS_LOGMN...
I have a performance problem with an Oracle select statement that I use in a cursor. In the statement one of the terms in the SELECT clause is expensive to evaluate (it's a PL/SQL procedure call, which accesses the database quite heavily). The WHERE clause and ORDER BY clauses are straightforward, however. I expected that Oracle woul...
I'm trying to fetch a genealogy tree of animals from my Oracle database. Here's the table: Animal ------------------------ Animal_ID Parent_Male_ID Parent_Female_ID .... .... ------------------------ If I specify an animal, I can get all of its descendants (on the male side) using something like this: SELECT * FROM animal START WITH...
Hi, Wonder if anyone can help me understand how to sum up the column of single column, ie a list of costs into one total cost. I have been looking into this, and I think I'm on the right lines in undertsanding i need to sum the query, treat it as a subquery. However I'm not having much luck - do I need to give the subquery an alias, or...
I'm having trouble writing a query. I have a support tabled called 'MYTABLE' and it has a column called 'TABLENAME' that can have one or many table names in it. Multiple Tables are separated with commas. Example: TBLUSER TBLUSER, TBLACCOUNT I'm trying to write an query that will identify any entries in the MYTABLE table that are no...
I have been following some MVC tutorials that connect to a sql mdf database and was wondering if there were any tutuorials that existed out there that show you how to create a data model using an Oracle database. The company I work for uses Oracle on the back end so getting MVC to tie into Oracle as the Model would help me greatly. Thank...