Saturday, 10 May 2008
|
| Oracle Reports, PDF to XML Emece 02:40:21 |
| | Hi. Sorry by my bad english, I speak spanish.
I have a PDF Oracle Report Service (the URL is the usual, http://server:7779/reports/rwservlet)
I want to get the PDF in XML format, without using the Report Builder. Something like this:
http://server:7779/reports/rwservlet/getjodib1234?GiveMeTheReportInFormat=XML
Is possible? The parameter DESFORMAT doesn't work in the URL. Thanks
|
| Options | 3 answer | Add comment |
Wednesday, 7 May 2008
|
| TNSPing 03505 Error Tim Pascoe 11:59:48 |
| | I've looked through the archives of the group, and seen lots of posts on this, but none have solved my problem yet.
I have the Oracle 9i client installed on a machine, in order to provide connectivity to a SQL-Server box. I will be creating linked servers in SQL-Server to several different Oracle instances.
I originally installed the 10g client, but discovered that it will not connect to one of the legacy Oracle installations (8.1 I believe), so uninstalled it and installed 9i.
I am able to connect to the Oracle instances using the Net Manager just fine, but when I try and TNSPING to one of the TNSNAMES entries, I get the 035050 error. The Linked server in SQL-Server is also unable to make the cnnection, but provides very little in the way of usable error message.
The sqlnet and tnsnames files are below:
NAMES.DEFAULT_DOMAIN = ontario.int.ec.gc.ca
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
PYR = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = frodo)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = frodo)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = as03.pyr.ec.gc.ca)) ) (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = drake)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = drake)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = as02.pyr.ec.gc.ca)) ) )
ACBIS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 131.235.28.21)(PORT = 1521)) ) (CONNECT_DATA = (SID = ATST) ) )
|
| Options | 2 answer | Add comment |
Thursday, 20 March 2008
|
| ORA-00036 maximum number of recursive SQL levels (string) exceeded EdStevens 14:01:02 |
| | Platform: Solaris 9, Oracle EE 8.1.7.4, Oracle EE 10.2.0.1
Two databases on the same box, call them eps8pd (8.1.7.4) and epspd (10.2.0.1)
In eps8pd, I created a db link pointing to epspd:
CREATE PUBLIC DATABASE LINK "LNK_EPSPD" CONNECT TO "NOBELEPS" IDENTIFIED BY "********" USING 'EPSPD'
then, connected to eps8pd as NOBELEPS (same user exists on both db's):
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production select count(*) from user_tables@lnk_epspd; select count(*) from user_tables@lnk_epspd * ERROR at line 1: ORA-02068: following severe error from LNK_EPSPD ORA-00603: ORACLE server session terminated by fatal error ORA-00604: error occurred at recursive SQL level 52 ORA-00036: maximum number of recursive SQL levels (50) exceeded ORA-00604: error occurred at recursive SQL level 52 ORA-00036: maximum number of recursive SQL levels (50) exceeded
Searching the ng archives, MetaLink, and Google on ORA-00036 gives a few hits, all talking about the likelyhood of a recursive trigger. But as you can see, my example is a simple select that shouldn't generate much recursive SQL. Linking FROM the 10.2 db TO the 8.1 db causes no problems. I realize that this may be an un-resolvable problem with 8 -> 10 connections, but am making one last attempt to find a possible work-around before going to plan 'D'.
Thanks.
|
| Options | 3 answer | Add comment |
Thursday, 14 February 2008
|
| Oracle ODBC/OLEDB - can't get it to work Martijn Tonies 16:33:02 |
| | Hi all,
I've just did another re-install of the Oracle 10g client.
I can see the Oracle ODBC driver in the Windows ODBC Control Applet. But whenever I select it, it returns an: --------------------------- Microsoft ODBC Administrator --------------------------- The setup routines for the Oracle in OraClient10g_home1 ODBC driver could not be loaded due to system error code 998. --------------------------- OK ---------------------------
As for the OLEDB driver - it doesn't show up in the list of available OLEDB drivers.
Does anyone have an idea?
I've searched, but cannot find a workable solution to get this ODBC working
-- With regards,
Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com
|
| Options | 4 answer | Add comment |
Wednesday, 19 December 2007
|
| ORA-1113 signalled during: alter database open Stephen 03:18:25 |
| | I was hasty and I did a cold backup incorrectly, I believe. I shut the database down and backed up only the data files for one (out of 4 tablespaces). I started Oracle and proceeded to work on all 4 tablespaces. Today I needed to quickly roll back the tablespace I "backed up", so I stopped Oracle and pasted the backed up datafiles back in. Now Oracle won't start...
ORA-1113 signalled during: alter database open
Is there a command I can run to tell Oracle I am sure these data files are consistent, and to let me open the database? Even point me in the right direction and I will appreciate it.
Thanks, Stephen
|
| Options | 11 answers | Add comment |
Tuesday, 23 October 2007
|
| Unable to see the contents of only ... Guest 08:22:06 |
| | Unable to see the contents of only one view.
Other views are working properly.
Only oneview is creating some problem and throwing the following error:
ORA-03113: end-of-file on communication channel
Help me please |
| Options | Add comment |
Thursday, 20 September 2007
|
| Development environment Oradba Linux 18:47:15 |
| | How to really use the alter session set current_schema='APPUSERID' in a devl env for a set of 20+ developers ?
|
| Options | 22 answer | Add comment |
Wednesday, 22 August 2007
|
| Time diff Eugene 00:18:54 |
| | Hi all, I have two columns representing start_datetime and end_datetime. They look like 1085008980 and 1085009504 respectively. They are stored in UTC format (number of seconds from '15/12/1970'). How do I calculate difference in hours:minutes:seconds?
Thanks, Eugene
|
| Options | 8 answers | Add comment |
Tuesday, 12 June 2007
|
| http server causes multiple instances of java.exe Pat Paulson 12:09:27 |
| | Hi,
I installed Oracle 9i Personal and am now running it with jdk1.5.0_01 (I did have an earlier version but uninstalled and reinstalled with the newer version, hoping for a resolution, but no go). The problem I have is when the HTTP Server is running it keeps kicking of multiple instances of java.exe (as seen in the task manager) and drags the system down. As soon as I stop it via Admin Services the java.exe spawning stops, as soon as I start it up again...off it goes. I can watch task manager and it adds another java.exe about every 2-3 seconds.
I'm an applications developer experienced in developing pl/sql but with the resources of three DBA's to take care of the complicated stuff like this! Now I'm out of work and was going to play around with this, but can't find any documentation on this problem. So try to be gentle with me......
Any help would be appreciated!
Thanks, Pat
|
| Options | 3 answer | Add comment |
Sunday, 15 April 2007
|
| obj_privilege in dba_audit_trail Terry Dykstra 15:32:53 |
| | I'm trying to find out what privilege belongs to each position in the obj_privilege column in the dba_audit_trail view. For example, position 10 seems to be 'select' privilege, position 7 is 'insert'. Does anyone have a complete description? Oracle 9.2.0.5
-- Terry Dykstra Canadian Forest Oil Ltd.
|
| Options | 2 answer | Add comment |
Monday, 26 March 2007
|
| XMLType and ClassCastException: oracle.sql.OPAQUE Languy 10:28:53 |
| | Hi There,
I'm trying to create a XMLType using the SELECT XMLTYPE('expr') FROM DUAL. When I'm trying to fetch the data I'll get an ClassCastException and I'm wondering why.
java.lang.ClassCastException: oracle.sql.OPAQUE oracle.xdb.XMLType PA.getXmlType(java.lang.String) PA.java:100
-- source snip -- sql = "SELECT XMLType('"+ xmlstr +"') FROM DUAL"; System.out.print(sql);
conn = getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); if (rs.next()) { xmlObj = (XMLType)rs.getObject(1); // Line 100 System.out.println(xmlObj.toString()); } -- source snip --
I hope any one will be helpful with this problem.
Thanks in regards, Jess
|
| Options | 2 answer | Add comment |
Saturday, 13 January 2007
|
| trivia: origin of names for UPPER() and LOWER() Mark C. Stock 06:28:56 |
| | it occurred to my that for some whose native tongue is not english, the names of these two functions might seem a bit odd, as would the phrases 'upper case' and 'lower case'
so, trivia question: what's the derivation (etymology, if you will) of the terms 'upper case' and 'lower case' from which these functions get their name?
++ mcs
|
| Options | 17 answers | Add comment |
Wednesday, 29 November 2006
|
| NULLs Andrew Clark 00:31:07 |
| | Hello,
I have an application whose database was recently upgraded from 7 to 9i. In a bit of code, columns are compared that may both be null. In Oracle 7, will two columns compare equal if they are both NULL? In 9i it seems that they do not and I have to change it to NVL(column1) = NVL(column2).
Thanks, Andrew
|
| Options | 30 answers | Add comment |
Friday, 20 October 2006
|
| Oracle query Amritha Datta 11:07:42 |
| | Can anyone help me to get results from this tricky query:
Select Recnum, trim(Both From Family_ID), trim(Both From DOB) From abc Where File_Key = 2470 And Sub_File_Key = 1 and Reason is null and trim(Both From Family_ID) IN ( Select trim(Both From Family_ID) From abc Where File_Key = 2470 And Sub_File_Key = 1 and Reason is null And trim(Both From Family_ID) IN ( select trim(Both From Family_ID) From abc Where File_Key = 2470 And Sub_File_Key = 1 and reason is null group by trim(Both From Family_ID) having count(trim(Both From Family_ID)) > 1 ) group by trim(Both From Family_ID), trim(Both From DOB) having count(trim(Both From DOB)) > 1 ) group by trim(Both From Family_ID), trim(Both From DOB) having count(trim(Both From Family_ID) || trim(Both From DOB)) > 1
I know I should not use group by with out all the fields listed in select statement. But my intension is to have Recnum based on these conditions.
Can anyone come across this kinda issue? Is there any work arrond on this ?
Thanks.
|
| Options | 12 answers | Add comment |
|
| Running Setup in Oracle Developer Suite 10g for windows XP Pro SP2 Jean-Benoit MORLA 02:42:18 |
| | Hi,
I can't get past the first screen in the setup/installer of Oracle Developer Site. There are 3 fields: Source -> points to the products.jar file Destination ->Origin Oracle Home directory is a variable "OraDb10g_Home1" Destination ->Path:C:\oracle\product\10.1.0\db2 Now if I click the button "Installed Products", I see a tree with a "OraDb10g_Home1" leaf and the message: not available. How can I fill these fields with the correct values? Many thanks jbmorla@tiscali.fr
|
| Options | 3 answer | Add comment |
Thursday, 19 October 2006
|
| Problem is the pl/sql variable can have only 1000 bytes despite being varchar2(4000) is that a bug? Colin_lyse 15:45:53 |
| | In article <42a4b693$0$50296$bb4e3ad8@newscene.com>, colin_lyse@98fgfgs.com (colin_lyse) wrote:using oracle 9.2.0.3.0 running on unix starfire Sun OS 2.7 when doing a stored procedure we are getting the following errror when trying to concatenate 2 variables (variable sqlSqtmt) Undeclared Identifier ' sqlStmt' we are doing the following (code not complet took parts out for brevity) CREATE OR REPLACE procedure getPCBDetailResults( txtLocation in Varchar2, errResultMessage OUT VARCHAR2, errResultValue OUT INTEGER ) as sqlStmt Varchar2(2000); sqlStmt2 Varchar2(4000); whereClause Varchar2(2000); orderClause Varchar2(2000); If txtLocation is not null and length(txtLocation) > 0 Then whereClause := ' toa_equipmt.location like ''' || txtLocation || ''' and '; End If; whereClause := whereClause; orderClause := ' order by position.equipment_position, oa_equipmt.apprtype '; sqlStmt :='insert into cas_data_tmp(location, manufacturer, serial_num, equip_num, appr_type, equip_type, region, area, e_code, ' and e2.ref_id = e1.enterprise_id and '; whereClause := whereClause || orderClause; sqlStmt2 := sqlStmt || whereClause; the error occurs on the last line. we get the Undeclared Identifier ' sqlStmt2' error. we tried just using sqlStmt but got the same error we tried also sqlStmt := sqlStmt || ' xx '; and got the same error. here is the program where the 1000k problem exists
CREATE OR REPLACE procedure getPCBDetailResults( txtLocation in Varchar2, txtFromPCB in Varchar2, txtToPCB in Varchar2, txtFromSampleDate in Varchar2, txtToSampleDate in Varchar2, txtEquipmentType in Varchar2, txtRegion in Varchar2, txtArea in Varchar2, txtEquipNum in Varchar2, txtManufacturer in Varchar2, txtSampleNumber in Varchar2, errResultMessage OUT VARCHAR2, errResultValue OUT INTEGER ) as sqlStmt Varchar2(4000); sqlStmt2 Varchar2(4000); whereClause Varchar2(2000); orderClause Varchar2(2000); sqlStmtFluid Varchar2(2000); orderByFluid Varchar2(2000); whereClauseFluid Varchar2(2000); len number; len_order number;
begin orderClause := ' order by position.equipment_position, toa_equipmt.apprtype '; len_order:= length(orderClause); --this one failes it is 1042 bytes in size (982 plus the 60 bytes in the orderclause
sqlStmt := 'insert into cas_data_tmp(location, manufacturer, serial_num, equip_num, appr_type, equip_type, region, area, e_code, equip_id, equiptype_id, toa_equip_id, position_id) select toa_equipmt.location, toa_equipmt.mfr as mfr, toa_equipmt.serialnum as serialnum, position.equipment_position as equipment_number, toa_equipmt.apprtype as apprtype, equiptype.description as equipment_type, e1.name as region, e2.name as area, position.pos_no as e_code, equipment.equip_id, equiptype.equiptype_id, toa_equipmt.toa_equip_id, position.position_id from toa_equipmt, position, equipment, equiptype, enterprise E4, enterprise E3, enterprise E2, enterprise E1where toa_equipmt.equip_id = equipment.equip_id and equipment.position_id = position.position_id and equiptype.equiptype_id = equipment.equiptype_id and equipment.enterprise_id = e4.enterprise_id and e4.ref_id = e3.enterprise_id and e3.ref_id = e2.enterprise_id and e2.ref_id = e1.enterprise_id and ';
-- this one works it is 999 bytes in size (939 plus the 60 bytes in the orderclause)
--sqlStmt := 'insert into cas_data_tmp(location, manufacturer, serial_num, equip_num, appr_type, equip_type, region, area, e_code, equip_id, equiptype_id, toa_equip_id, position_id) select toa_equipmt.location, toa_equipmt.mfr as mfr, toa_equipmt.serialnum as serialnum, position.equipment_position as equipment_number, toa_equipmt.apprtype as apprtype, equiptype.description as equipment_type, e1.name as region, e2.name as area, position.pos_no as e_code, equipment.equip_id, equiptype.equiptype_id, toa_equipmt.toa_equip_id, position.position_id from toa_equipmt, position, equipment, equiptype, enterprise E4, enterprise E3, enterprise E2, enterprise E1where toa_equipmt.equip_id = equipment.equip_id and equipment.position_id = position.position_id and equiptype.equiptype_id = equipment.equiptype_id and equipment.enterprise_id = e4.enterprise_id and e4.ref_id = e3.enterprise_id and e3.ref_id = e2.enterpr '; sqlStmt := sqlStmt || orderClause; len:= length(sqlStmt);
-- execute immediate sqlStmt; -- commit; exception when others then errResultValue := SQLCODE; errResultMessage := SQLERRM; end; /
|
| Options | 5 answers | Add comment |
|
| Which to download? Alan 14:10:01 |
| | As I am a newbie to Oracle would like to know besides the 10g database server, what other I need to download to look at the Oracle 10g ?
How about the something like Form 2000 or Designer 2000 ?
|
| Options | 9 answers | Add comment |
Thursday, 12 October 2006
|
| parse calls Guest 08:21:26 |
| | All, I'm curious why I'm getting a reparse for every execution in the following scenario (this is a simplified example of a real problem): select * from dual;
D - X select * from dual;
D - X select * from dual;
D - X select parse_calls, executions from v$sqlarea where sql_text like 'select * from dual%';
PARSE_CALLS EXECUTIONS ----------- ---------- 3 3
I have cursor_sharing=FORCE and session_cached_cursors=20
TIA
|
| Options | 2 answer | Add comment |
Wednesday, 11 October 2006
Wednesday, 4 October 2006
|
| Connection time outs Rich Campbell 20:40:46 |
| | Version 9.2.0.4.0. Solaris 8 Occasional TNS-12535 during peak load times from client application. DB Server is not CPU bound. No entry in listener.log. Am I hitting an OS/TCP limit on the database server, such as listen queue size?
|
| Options | 2 answer | Add comment |
Tuesday, 19 September 2006
|
| My apologies Guest 18:26:09 |
| | Hello,
It was brought to my attention to a member of this group that my job positing yesterday is not welcomed in this group. To all of you who found my posting inappropriate please accept my apologies. I was unaware that Oracle job postings are not allowed.
Regards, Laird Goolsby Universal Software Corp.
|
| Options | 8 answers | Add comment |
Monday, 11 September 2006
|
| all_triggers Dw 16:11:14 |
| | Hello
I don't want to grant the users access to views such as dba_triggers or dba_constraints. But there is requirement that the user needs to see the triggers owned by some other schema. Is there a way for a user to see the data from all_triggers when he doesn't own the trigger? Any ideas? Version 9.2.0
Thanks D
|
| Options | 7 answers | Add comment |
Thursday, 7 September 2006
|
| ORA-01036: illegal variable name/number chandrika h via DBMonster.com 17:48:11 |
| | Sir, Please any one can help me about this error.I have gone through internet but i couldn't get solution for this error.Actually i am calling a sql procedure in c++ and i am getting this error.I am not able to rectify this error from past three days pls any one can help me abt this.I am embedding procedure like this.
ProcReturnType DBProc_Receive_validate_boxid_duplication(char* box) { ProcReturnType ProcReturn; boolean retStatus = FALSE; char p_msg[120]; ProcReturn.Status = FALSE; char localRet[120];
GlbOracleErrorFlag = FALSE;
{ struct sqlexd sqlstm; sqlstm.sqlvsn = 12; sqlstm.arrsiz = 13; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.stmt = "declare localRet BOOLEAN ; BEGIN PRF01 . CHECK_FOR_BOXID_DUPLICATION( :GlbC\ omId , :box , localRet , p_msg ) ; IF ( localRet\ ) THEN :retStatus := 1 ; END IF ; END ;"; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )1521; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)256; sqlstm.occurs = (unsigned int )0; sqlstm.sqhstv[0] = (unsigned char *)GlbComId; sqlstm.sqhstl[0] = (unsigned long )0; sqlstm.sqhsts[0] = ( int )0; sqlstm.sqindv[0] = ( short *)0; sqlstm.sqinds[0] = ( int )0; sqlstm.sqharm[0] = (unsigned long )0; sqlstm.sqadto[0] = (unsigned short )0; sqlstm.sqtdso[0] = (unsigned short )0; sqlstm.sqhstv[1] = (unsigned char *)box; sqlstm.sqhstl[1] = (unsigned long )0; sqlstm.sqhsts[1] = ( int )0; sqlstm.sqindv[1] = ( short *)0; sqlstm.sqinds[1] = ( int )0; sqlstm.sqharm[1] = (unsigned long )0; sqlstm.sqadto[1] = (unsigned short )0; sqlstm.sqtdso[1] = (unsigned short )0; sqlstm.sqhstv[2] = (unsigned char *)p_msg; sqlstm.sqhstl[2] = (unsigned long )1002; sqlstm.sqhsts[2] = ( int )0; sqlstm.sqhstv[3] = (unsigned char *)&retStatus; sqlstm.sqhstl[3] = (unsigned long )sizeof(int); sqlstm.sqhsts[3] = ( int )0; sqlstm.sqindv[3] = ( short *)0; sqlstm.sqinds[3] = ( int )0; sqlstm.sqharm[3] = (unsigned long )0; sqlstm.sqadto[3] = (unsigned short )0; sqlstm.sqtdso[3] = (unsigned short )0; sqlstm.sqphsv = sqlstm.sqhstv; sqlstm.sqphsl = sqlstm.sqhstl; sqlstm.sqphss = sqlstm.sqhsts; sqlstm.sqpind = sqlstm.sqindv; sqlstm.sqpins = sqlstm.sqinds; sqlstm.sqparm = sqlstm.sqharm; sqlstm.sqparc = sqlstm.sqharc; sqlstm.sqpadto = sqlstm.sqadto; sqlstm.sqptdso = sqlstm.sqtdso; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); if (sqlca.sqlcode < 0) sql_error("ORACLE error--\n"); }
SET_RETURN_STATUS(); if (GlbLogStatus==TRUE) { char LogBuf[1500]; sprintf(LogBuf,"PRF01.check_for_boxid_duplication(%s,%s,%s,%s)", GlbComId, box,localRet,p_msg); Log(LogBuf); }
ERROR_HANDLER(); return(ProcReturn); }
|
| Options | 12 answers | Add comment |
Monday, 14 August 2006
|
| Problem when WIndows 2000 Server is rebooted Guest 15:26:05 |
| | I am running Oracle 10.1.0.3 on Windows 2000 server. I have a few database instances. I have noticed that when Windows server is rebooted, once in a while (every 3 month or so). a database instance will not start properly. There are no error messages in alert.log file, however when one connects to database instance, it gives some error message.
As I stated problem happens only once in a while and it is also not tied to a specific database instance (I have 3 instances). Has anyone seen similar problem and knows how to fix it in Windows 2000 environment (I cannot move to UNIX, LINUX ...).
Thanks.
|
| Options | 21 answer | Add comment |
|