Oracle Database Forum

Hello dBforums members: I want to know what reference books are good for perparing for OCA and OCP exams. I found two by OraclePress

I have a problem with blank line inserted. Please help! This is how my SQL report looks like ACCEPT vf CHAR PROMPT "Vrsta fakture: " ACCEPT fk CHAR PROMPT "Faktura: " SET PAGES 72 set NEWPAGE 1

I have data in an oracle9i database that is in RTF format and I need to convert it to text format.. I have not found a way to do it with SQL or PL/SQL. Is there a tool that can access the db an do the conversion into a new column? I dont want to extract to a file and then put it back into the db unless I have to..

Hi, How do dependencies work with Oracle reports? I have a set of developers creating reports in Report Builder 6 w/ Oracle 8i and every time the stored packages change that the report uses, I am asked to recompile the reports. I guess what I am trying to understand is when you run the report (from the .rep file) why does it fail if the...

Hi, I have a 8.1.7 client on NT4 using a Unix 8.1.7 databases. - When I execute a statement like : select count(*) from XXX I have the right number of records.

Hi, When I try to execute the command: apache -k start in the ORACLE_HOME/apache/apache it shows an error message: Syntax error on line 6 of c:/oracle/oraias/apache/conf/mod_osso.conf: unable to deobfuscate the SSO server config file, c:/oracle/oraias/apache/apache/conf/osso/osso.conf, error Bad padding pattern in the last block.

Hi! What is standard and direct way (within Oracle 9.2 stored procedures) for writing binary data from Oracle to external file on disk? We have tried to use UTL_FILE package, but it operates on files consisting out of "line" of size no more than 32767 bytes and adds new_line symbol upon closing files. Also we checked out interMedia types...

I have a query I use to validate that there are no other records with the same descriptions - a table for items. Now the querry ends up like this: SELECT COUNT(ITMID) AS COUNT FROM TBLITEM WHERE

I need to move a database to a new machine; we are doing a hardware upgrade. The system has the same OS, the same version of Oracle and the same hard drive layout. Can I just shutdown the database on the old machine and copy the pfile, control files, online log files, data files and archived log files into the same paths they where on the...

hi i have a table c_table with two columns no, date it contains records no n_date 1 10-AUG-03 2 21-AUG-03

I have a database that is going to contain a lot of documents i ..DOC,.TXT,.PPT,.PDF etc. formats. I want to index the documets to use a free text search on the database table. I also want to insert and retrieve the documents using .NEt (C# or VB.NET) ! Is there anyone of you out there that can give me some tips, links or other helpful...

Hi all, I've been digging this problem almost 3 days now. I created some 'normal' views and then join them all together to create a materialized view but I got this error message: "Subquery expressions not allowed here" I use subqueries *only* in 'normal' views.

Here's a sample result from the following statement: select dept, sum(cost) from dept group by dept; dept sum(cost) ---- -------- null 1000 200 20

What's wrong with my sample ? SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production

Hi, I get an error "ORA-22275: invalid LOB locator specified" when I try to update a BLOB field. I'm using ODBC ver3.0, and Oracle driver v8.1.7.0 for Windows. Are there any special steps needed to do this update? thanks, kjr

Is there any way to specify an input mask for an IP-Adress in pl/sql? If not, I would write a function that would handle this, but don't want to bring down my performance too much, so I was wondering if there was another way to do this in pl/sql, e.g. the way you can specify a mask for a telephone number.

Does anyone know how to integrate Oracle9iAS and JBuilder9???

Hi, i'm just starting to learn about oracle 9.2. (about 1 year) i have loaded the database software onto a linux box. I want to try to provide some minor ftp service for an idea i'm working on,where some files are stored in the database and can be accessed over an ftp link. i beleive i can use

As an SQL newbie, why do I need to define columns prior to getting column_value when I can fetch_rows(cur_hdl) ?? Does not column_value get the value at position x at the current cursor position and fetch_rows gets a row for a given cursor and increment cursor position ? So why define_column ? Example. -- describe defines...

Hi, My local procedure needs to call a remote stored procedure which dblink name is built at the run time depending on the input parameter to the local procedure. Therefore depending on the input parameter, the remote procedure may reside at different remote databases. Try to avoid hardcode value in "if/elsif". Thinking to use dbms_sql and...

Greetings, I have a table MYTABLE ( msg_id RAW(24) NOT NULL) , .....) msg_id is the key, If I wanted to select a record using the OCI, the select is failing. I can see that the value exists using sqlplus. I guess I am not doing the Bind correctly. '414D51204D45525420202020202020203F2293C209CBD012' is a example value for msg_id, obtained...

hi, I have a insert trigger on a table. I want commit to happen after insert before invoking the trigger. So that if a quey is made before the completion of the trigger.Modified Data should be visible. Let me explain the why i want this. The triger calls a java stored procedure which invokes an external ejbclient which calls the ejb. The...

Hi everybody, I have a problem in Discoverer. The point is that I don´t want to refresh data each time I open a workbook. I want to mantain old reports. If I open a report without connecting to the database it refreshes as well. Does it mean that Discoverer is not a portable tool? Do you know how to do it, not upgrading data?

Hi, If I run my own exception at PL/SQL procedure do I need to do rollback or it would be done for me by system? I mean nothing would be saved anyway if error happens , even if I inicialize that error? Thanks

Hi , Oracle EE 8.1.7.0.0 on MS WIndows Advanced Server 2000 SP3 We have a proc which is using utl_file . procedure test_dump_csv as l_rows number; begin