|
|
Browse by Tags
-
Database Link in Oracle 11g
Hi, I'm trying to create a database link to an Oracle 11g database. I execute tyhe CREATE DATABASE LINK command without error pointing the a database that is present in TNSNAMES.ORA. On the server I have set GLOBAL_NAMES to be false in init.ora The error I'm getting is ORA-12154 - TNS:could not... -
Datapump Running Slow From PL/SQL Procedure (11g)
Hi, I'm writing a stored procedure to export tables using the Datapump API but it seems to be barely doing anything other than produce the two files, which the log file is empty and the data file is 4Kb. The code originally was in a cursor and exporting 16 partitions into 16 files. I've removed... -
Problem: Database Link Authentication Issue
Hi, I've created a database link that seems to be okay but have an authentication issue when trying to use it The username and password given to the CREATE DATABASE LINK statement are valid and the entry for the remote server is in TNSNAMES.ORA on the server but now I get: ORA-01017: invalid username... -
Problem: Want to drop a job that already exists but can't find it in user_jobs view
Hi, I've created a job as a normal user (not as dba user) and need to drop it but it appears there are no jobs in all_jobs or user_jobs to drop When I try and recreate the job I get an error saying job exists with the same name Any help appreciated -
Problem: Access Control List (ACL) Problems when using the UTL_TCP Package for FTP in Oracle 11g
Hi all, I'm using UTL_TCP to provide FTP functionality through Oracle and have set up ACL privileges for my Oracle user to connect to another server. I create a connection specifying port 21 and pass over a username, password, then change directory, and next I issue the PASV command and get back... -
Problem: Best Way To Call Web Service From PL/SQL on 11g
Hi, Can someone please tell me the best way to call a remote web service from PL/SQL using Oracle 11g Cheers -
Problem: Error message when attempting to update xmltype column with insertChildXML
hello, i try to update xmltype column with SchemaBased xsd, the first few attempt is alright; from the code snippet i attached, it returned me with these errors. i looked into the trace file and found this --------------- EnumerateLoadedModules64 failed with error -1073741819 Symbol file orasql11.SYM... -
Problem: Cannot enable a scheduled job from within a cursor loop
Hi, In a single procedure I am getting results from a cursor and using this information to schedule jobs but not enable them. Later in the same procedure, if all goes well, I want to enable these jobs so I process the same cursor and call DBMS_SCHEDULER.enable(job) The error I'm getting is insufficient... -
Problem: Calling Oracle 11g Web Service from .Net
Hi, I have Oarcle set up and exposing Web Services but cannot get a result when calling them from a .Net application. I get ORA-31011 (XML parsing failed) Can anyone give example code of a .Net application (preferably framework 2.0 or 3.x) calling an Oracle Web Service passing both string and date parameters...
Page 1 of 1 (9 items)