Imanmalik
asked on
ora-03114-not connected to oracle.
whenever I m running this query I m getting error. 03114
I ran this view itself it worked. but whenever I m running this statement it gives me the error.
any suggestion?
SELECT VW_SYMBOL.IDNO,VW_SYMBOL.C OMPANY, VW_SYMBOL.CODE_TYPE, VW_SYMBOL.APPROVAL_DATE,
VW_SYMBOL.ADDRESS1, VW_SYMBOL.ADDRESS2, VW_SYMBOL.CITY, VW_SYMBOL.STATE, VW_SYMBOL.ZIP_CODE, USA.STATE
FROM HMIS.VW_SYMBOL VW_SYMBOL,HMIS.USA USA
WHERE (VW_SYMBOL.STATE=USA.ABBRE V(+)) AND VW_SYMBOL.STATE='CA'
ORDER BY VW_SYMBOL.STATE
I ran this view itself it worked. but whenever I m running this statement it gives me the error.
any suggestion?
SELECT VW_SYMBOL.IDNO,VW_SYMBOL.C
VW_SYMBOL.ADDRESS1, VW_SYMBOL.ADDRESS2, VW_SYMBOL.CITY, VW_SYMBOL.STATE, VW_SYMBOL.ZIP_CODE, USA.STATE
FROM HMIS.VW_SYMBOL VW_SYMBOL,HMIS.USA USA
WHERE (VW_SYMBOL.STATE=USA.ABBRE
ORDER BY VW_SYMBOL.STATE
what oracle version are you using?
try to take out outer join (+) for a test if it runs ok without it.
here is the query:
SELECT VW_SYMBOL.IDNO,VW_SYMBOL.C OMPANY, VW_SYMBOL.CODE_TYPE, VW_SYMBOL.APPROVAL_DATE,
VW_SYMBOL.ADDRESS1, VW_SYMBOL.ADDRESS2, VW_SYMBOL.CITY, VW_SYMBOL.STATE, VW_SYMBOL.ZIP_CODE, USA.STATE
FROM HMIS.VW_SYMBOL VW_SYMBOL,HMIS.USA USA
WHERE VW_SYMBOL.STATE=USA.ABBREV AND VW_SYMBOL.STATE='CA'
ORDER BY VW_SYMBOL.STATE
try to take out outer join (+) for a test if it runs ok without it.
here is the query:
SELECT VW_SYMBOL.IDNO,VW_SYMBOL.C
VW_SYMBOL.ADDRESS1, VW_SYMBOL.ADDRESS2, VW_SYMBOL.CITY, VW_SYMBOL.STATE, VW_SYMBOL.ZIP_CODE, USA.STATE
FROM HMIS.VW_SYMBOL VW_SYMBOL,HMIS.USA USA
WHERE VW_SYMBOL.STATE=USA.ABBREV
ORDER BY VW_SYMBOL.STATE
ASKER
i already tried that. i get back
ora-03113
ora-03113
ASKER
I don't have any problem running other queries . I can run this view_symbol view it self. it works fine
but this query comes back with the error....
but this query comes back with the error....
Check if a trace file has been generated on the server (in <DB_DIR>/trace/udump).
ASKER
I don't have alert log access to this database since I don't maintain it.
if you guys can point me to the possible solution to this issue. why only this query creating this error?
if you guys can point me to the possible solution to this issue. why only this query creating this error?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe he kills your session because you consume excessive resources ? He should inform then...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ORA-03114 not connected to ORACLE
Cause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.
Action: Try again. If the message recurs and the program is user written, check the program.