Hi, I'm unable to connect Oracle 11 database remotely using following piece of code. However, same code works fine if I try to connect Oracle 9 database which is installed on my machine. What is missing ? ( I'm not getting any error, Lotus Notes hangs ) import lotus.domino.*; import java.sql.*; import oracle.jdbc.*; public class Jav...
Dear all we have a dot net application and it connecting to Oracle and fetching data and moving to SQL server. it was working very fine. just started giving error ORA-12560: TNS:protocol adapter error . Tnsping also giving this error. but if i stop this application and tnsping then its success. again starting the application on the firs...
When this code is executed in SQL Developer against Oracle 11g I get an error, begin dbms_scheduler.create_job( job_name => 'comuni_34', job_type => 'plsql_block', job_action => 'begin com_auth_api.expire_old_passwords; end;', start_date => to_date('2009-jan-01 01:15:00', 'yyyy-mon-dd hh24:mi:ss'), repeat_interval => 'freq=dai...
In Oracle how do I convert a "timestamp with time zone" to the current time zone of the server? I need to dynamically figure out what the current time zone of the server is. create table test_table1 (rec1 timestamp with time zone) insert into test_table1(rec1) values ( to_timestamp_tz('1/1/1900 09:00:00 AM US/EASTERN','dd-mm-yyyy hh:mi...
CREATE TABLE DIALOGUE_TABLE(EXPIRE_TIME TIMESTAMP); Following code snippet is inside stored proc :- PO_EXPIRETIME :- OUT PARAM of procedure a varchar2 SELECT TO_CHAR(SYS_EXTRACT_UTC(EXPIRE_TIME)) INTO PO_EXPIRETIME FROM DIALOGUE_TABLE; When I run Stored Proc from server using EXEC and print PO_EXPIRETIME time stamp is pr...
Hi, I may be asking something silly but I don't see any sql*plus or any GUI kind of interface to connect my Oracle server remotely. I tried SQL Plus but it's a command line interface, don't know what to do with that. ...
Hi, In my DB, I store various version numbers, like the following : OBJNAME Fix_6.0.0a.1 Fix_6.0.0a.2 I would like to sort them not according to last version element (the number behind the last .character. How do I write such SQL statement ? I guess it's something like SELECT SUBSTR(INSTR(OBJNAME, ".", -1)) as LAST_VERSION, OBJNAME ...
I have registered one XSD in oracle XMLDB. Also I have annotated one element as a CLOB as shown below. <xs:element name="data" xdb:SQLType="CLOB"> <xs:complexType> <xs:simpleContent> <xs:extension base="xs:string"> <xs:anyAttribute processContents="lax"/> </xs:extensio...
Where can be found implementations of built-in Oracle PL/SQL packages? For example, there can be found specification stdspec.sql with impl. stdbody.sql. But for package DBMS_ASSERT there is only spec. dbmsasrt.sql. Where can be found implementation? (using version 11.2) ...
There are parameterized error messages in Oracle database. For example, there is 01919, 00000, "role '%s' does not exist" in oraus.msg. If one issue some nonsense GRANT ... TO ... %s is substituted by this nonexistent privilege. It is possible to raise exception -1919 and supply some string to %s? Code: not_system_privilege EXCEPTION; ...
Hello, I have a VB.Net application that populates an Oracle 11g global temporary table. I can see data in the temporary table by loading it into a grid and everything looks correct. However, when I call an Oracle stored procedure from VB.Net that would manipulate the data in this temporary table, the stored procedure reports that my te...
Does SQL*Plus provide the help pages for its commands? Is there a way to access the help text from the SQL*Plus prompt, like this text for STARTUP? I tried SQL> man startup SP2-0734: unknown command beginning "man startu..." - rest of line ignored. SQL> startup -help SP2-0714: invalid combination of STARTUP options SQL> startup --help ...
I need to load data into an oracle DB using SQLLDR, but I need to pull parts of my table from two different INFILES using the different positions from those infiles? ...
Hi, i want know querys of third party software executed in my oracle server, anybody know how i can do that?i will use one time, can be trial software or script anything..thx ...
I use oracle 11g , and sql develper stop working becouse of virus attack :( THE PROBLEM is that i need to restore my database schema , the data is not important to recover , sql plus work properly , can i recover the schema from sql plus or folders of oracle program ??? pleaaaaaaaaaaaaaaaaaaaaaaaaaaaase help :( ...
What does oracleClose() and oracleCloseQuery() do in sqlj.runtime.ExecutionContext.OracleContext. Since we upgraded jdbc driver jar to ojdbc5.jar with the oracleClose() in the finally block we get the below exception when using resultset.next() and not with oracleCloseQuery(). Is it safe to use oracleCloseQuery(). The database is Oracl...
Can i user ODAC or another free provider in EF4? ...
Hi there, Just wondering if there's a way to run Rails tests without dropping the database. I'm currently only executing unit tests and am using the following rake command to do so: rake test:units. Thanks for the help in advance! Just in case this is relevant: Rails 3 Ruby 1.8.7 (MRI) Oracle 11g Database activerecord-oracle_enhan...
Hi, In my program I need to access the schema of an Oracle 11g database. I have been trying to get a list of tables using a query like this: SELECT t.TABLE_NAME, t.OWNER FROM ALL_TABLES t WHERE t.DROPPED = 'NO' ORDER BY t.TABLE_NAME The query works and I get back a list of tables. Unfortunately when querying some of the tables using ...
Caveats: Let me first clarify that this is not a question about whether to use surrogates primary keys or not. Also, this is NOT a related to identities (SQL Server) / Sequences (Oracle) and their pros / cons. I did get a fair bit of idea about that thanks to this, this and this Question: I come from a SQL Server background and have...