Oracle Help
in [SQL]
|
How to trace caller Hi, I'm trying to trace the caller of a procedure. I used that WHO_CALLED_ME procedure, but unfortunately for me it only returns 'anonymous block'. Any thoughts on this? Is this the end of the road? Because I have no idea on how to trace that one.......... Thx. ... 13 Aug 2008 16:56
Auditing I cannot seem to find any good documentation on this: We have a user logging in and executing a procedure which creats some data to be inserted into some table. Some key information is missing though. We do not know what the 'trail' is of that user and how he gets to the 'create data' section. We want to a... 12 Aug 2008 14:13
Dynamic PL/SQL - Get values from one cursor from another or alternatives? bpfh <numerista(a)gmail.com> wa: <snip> So 3 questions: I am going to assume by "label" you mean column name. In my experience, with 10g (don't know if they fixed any of this in 11): 1) Can I access the values FETCHed from a cursor by an index value rather than a label so that I can control it from a loop?... 11 Aug 2008 11:30
Dynamic PL/SQL - Get values from one cursor from another or alternatives? On Mon, 11 Aug 2008 03:06:29 -0700 (PDT), bpfh <numerista(a)gmail.com> wrote: I am fighting with PL/SQL and loosing... I have a database that changes on a regular basis and has over 200 columns... and the data needs to be exported to a file. You can use exp for this purpose. If you want to dump it to... 11 Aug 2008 10:28
Dynamic PL/SQL - Get values from one cursor from another or alternatives? Hi, I am fighting with PL/SQL and loosing... I have a database that changes on a regular basis and has over 200 columns... and the data needs to be exported to a file. My idea was to create the following cursors: CURSOR cAnnonceFields IS SELECT column_name FROM SYS.USER_TAB_COLUMNS where table_name = 'ANN... 11 Aug 2008 06:23
Access frontal interface for Oracle database Hello everybody, Is anyone able to give me some indications about how to develop an Access interface for an Oracle database ? I dispose of Access 2003 (11.6566.8107) SP2, Oracle 9i 9.2.0.1.0 and ODBC 3.525.1117.0, on Windows XP Pro 5.1.2600 SP2 Nu 2600. I failed executing an Oracle stored procedure from Ac... 20 Aug 2008 16:59
Jobs, Interview Questions, Certification, Knowledge Hi All, Please visit www.itjobguru.com/forum/index.php, if you are 1. Looking for a Job Change Java, .NET, Oracle, SQL Server, Informatica, Cognos, SAP 2. For Latest Interview Questions Java, .NET, Oracle, SQL Server, Informatica, Cognos, SAP 3. Planning to write Certification Java, .NET, Oracle, S... 11 Aug 2008 13:34
monitor cluster interconnect performance Hi, We have a 10g service that is load balanced between 2 RAC nodes. We noticed that query runs about 3x slower if the service is load balanced on both nodes vs running the service on a single node. We did verify that all traffic runs on the private network. On OEM, the GC block access latency was within 12 ms and... 9 Aug 2008 12:33
SQL dumps for version control I�d need to generate SQL dumps to store in a version control system. I�m not asking for advanced features like upgrade/downgrade scripts or the like. My requirements are something like this: - I need to store the structure of specific tables (not all); providing the table name should automatically backup all r... 12 Aug 2008 17:19
Triggers de-compile themselves Hi there. We're running: Oracle9i Release 9.2.0.8.0 - 64bit Production PL/SQL Release 9.2.0.8.0 - Production "CORE 9.2.0.8.0 Production" TNS for Solaris: Version 9.2.0.8.0 - Production NLSRTL Version 9.2.0.8.0 - Production (that's from select * from v$version;) A web application connects to database on ... 7 Aug 2008 13:28 |