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 |
|
