A Wetpaint Site

Internet Explorer 6.0 is not supported. Please try IE 8 or Firefox.

Home
Discussions
Photos
Videos
News
Updates
Droplets
Members

Location: PL/SQL

Page Threads

Post a new thread

Showing 5 threads

Started By

Thread Subject

Replies

Last Post

smit_sign

Duplicate names of datafiles

Jun 29 2009, 5:51 AM EDT by samrat.wani

Thread started: Feb 14 2009, 9:47 AM EST Watch

Can some one please provide the script to check the duplicate datafiles in database.

Thanks
Smit

out of found this valuable. Do you find this valuable?

Keyword tags: Duplicate names of datafiles

Post reply

Show Last Reply

Last Reply:
RE: Duplicate names of datafiles
By: samrat.wani, Jun 29 2009, 5:51 AM EDT

Here is your answer:

set lines 130
set pages 2000
col file_name for a50
break on tablespace_name

select tablespace_name, file_name
from dba_data_files ddf ,
(
select substr(file_name,16) sstr
from dba_data_files
group by substr(file_name,16)
having count(substr( file_name ,16))> 1
) dup
where instr(ddf.file_name, dup.sstr) > 0;

out of found this valuable. Do you find this valuable?

jcgeorge

PL-SQL Context package Information

Oct 4 2008, 8:59 AM EDT by jcgeorge

Thread started: Oct 4 2008, 8:59 AM EDT Watch

Hi ,

I have an application wherein I have a flow with PL-SQLs package are called within other

eg : PACKAGE1.PROCEDURE1 Calls PACKAGE2.PROCEDURE2 Calls PACKAGE3.PROCEDURE3

Since the number of packages and calling hierarchy is large , is there any way that I can get the current context package and procedure without using any custom registry?

Thanks

Joseph

out of found this valuable. Do you find this valuable?

Keyword tags: None

Post reply

sabraha5

Base64 Encoding/Decoding from PL/SQL

Jul 28 2008, 6:33 AM EDT by sabraha5

Thread started: Jul 16 2008, 11:21 AM EDT Watch

Does anyone know of a way to do Base64 encoding/decoding from within PL/SQL? Thank you for your help!

4 out of 5 found this valuable. Do you find this valuable? Do you?

Keyword tags: Base64 PL/SQL PL/SQL Intro

Post reply

Show Last Reply

Last Reply:
RE: Base64 Encoding/Decoding from PL/SQL
By: sabraha5, Jul 28 2008, 6:33 AM EDT

Hi Niels,

Thank you for your reply! I Base64 encoding/decoding was actually the least of my issues...my main problem has been trying to decrypt a DES3 encrypted file using Java API from PL/SQL using the DBMS_OBFUSCATION_TOOLKIT. I posted on the ORACLE Community Forum about my issue. It seems I can't decrypt (back to original data) the DES3 encrypted data from Java API. I thought it was issue with key generated from Java API, so I generated a key from PL/SQL...but that did not work either. I am using the javax.crypto.* package to encrypt the data...so now I am trying to import that package into an Oracle 9i database (which I have problems with also).

Sunish

0 out of 2 found this valuable. Do you find this valuable? Do you?

sabraha5

PL/SQL DES3 Encryption/Decryption

Jul 22 2008, 4:40 PM EDT by sabraha5

Thread started: Jul 22 2008, 4:33 PM EDT Watch

We are trying to decrypt data written to tables from a Java program which used javax.crypto.Cipher (Cipher.getInstance("DESede")) to encrypt the data ; the DBMS_OBFUSCATION_TOOLKIT has functions/procedures to perform DES3 functionality ; the Java program uses javax.crypto.SecretKeyFactory to generate the secretkey (keyfactory.generateSecret(new DESedeKeySpec(keyBytes))) which is used to do the actual encryption (cipher.init(mode, secretKey)) ; do I need to call the DES3GetKey with the key which was passed into the generateSecret method and then call the DES3Decrypt with the key returned from the DES3GetKey call?

out of found this valuable. Do you find this valuable?

Keyword tags: PL/SQL PL/SQL Intro

Post reply

Show Last Reply

Last Reply:
RE: PL/SQL DES3 Encryption/Decryption
By: sabraha5, Jul 22 2008, 4:40 PM EDT

I am trying to use the DES3GetKey function from the DBMS_OBFUSCATION_TOOLKIT package as below and getting the following error...

ORA-06550: line 5, column 3:
PLS-00307: too many declarations of 'DES3GETKEY' match this call
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

DECLARE
l_key VARCHAR2(60) := 'testkey';
l_raw RAW(60);
BEGIN
DBMS_OBFUSCATION_TOOLKIT.DES3GetKey(
DBMS_OBFUSCATION_TOOLKIT.TwoKeyMode
, UTL_RAW.cast_to_raw(l_key)
, l_raw);

DBMS_OUTPUT.put_line('Key : ' || UTL_RAW.cast_to_varchar2(l_raw));
END;

I am getting same error trying to use the DES3Encrypt and DES3Decrypt functions also. Do I have to specify the call to the function differently? Thanks!

out of found this valuable. Do you find this valuable?

wikiponic

PL/SQL Webservices

Jan 24 2008, 4:31 AM EST by pvzweden

Thread started: Jan 22 2008, 3:27 AM EST Watch

Hello,

I created a procedure which contains couple of htp.prn statements which I used to output my content.
However when I create my webservice out of those procedures I get errors.
Anybody tried this before, kindly provide your thoughts and inputs.

Thanks

Internal Server Error (Caught exception while handling request: java.rmi.RemoteException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 328
ORA-06512: at "SYS.HTP", line 1322
ORA-06512: at "SYS.HTP", line 1397
ORA-06512: at "SYS.HTP", line 1689

0 out of 9 found this valuable. Do you find this valuable? Do you?

Keyword tags: PL/SQL PL/SQL Intro

Post reply

Show Last Reply

Last Reply:
RE: PL/SQL Webservices
By: pvzweden, Jan 24 2008, 4:31 AM EST

With one of the calls, does the data by accident only contain numbers? Because oracle then might the prn function which uses a number as data in.
You then would just have a normal problem of data containing a dot when oracle expects a comma or the other way arround.

You could also try to open the package source of the sys htp package and look what happens at lin 1689

2 out of 6 found this valuable. Do you find this valuable? Do you?

Application Express	Advantage with Oracle PL/SQL, Pro*C Process code generation interface	Base64 Encoding/Decoding from PL/SQL
PL/SQL DES3 Encryption/Decryption	Cheap Apex Hosting	PL/SQL Best Practices
PL/SQL Webservices	Middleware Certification	Designing PL/SQL apps

Location: PL/SQL

Page Threads

Related Content