Hi All,
I have an oracle procedure which takes in some parmeters and passes the output as SYS_REFCURSOR variable to some other schema (when called). Problem is when the other schema tries to use this cursor, they are getting error- “Invalid Operation, DataRead is Closed”. I am able to read in the contents of this cursor using loop and fetch in my own procedure. Can someone please throw some light as to where the problem might be?...
sainiamit25
Last Activity: Jun 22 '09, 07:32 AM
Joined: Jul 3 '07
Location:
-
Problem with REFCURSOR
-
Hi,
Thanks for the help. I was able to insert xml as clob in one of my tables. So now my code works perfectly when i have one file in teh specific directory. But now the requirement is :-
(1) I have one logical directory.
(2) There i have 10 or 15 files with any arbitary name.
(3) My code should pick them one by one and insert them into database.
There is no limit on the number of files... -
Hi,
i don't know how to do that. Can you please send me a sample code for doing that?
Regards,
Amit...Leave a comment:
-
Inserting XML into Oracle Table
Hi All,
I want to pick one xml file from a location and insert it into a coulmn in the database (CLOB). Can you please let me know how can i do that? Steps should be:-
(1) There is a file A.xml in a location.
(2) My code runs and puts the file in the table column.
eg if i select data from this coulmn, i should get the something like this:-
<?xml version="1.0" encoding="UTF-8"?>... -
creating materlized view in another schema using dblinks
Hi,
I want to create a materlised view log in my database A and materlised view in some other database B. I was successful in creating materlised view in database B (after creating a dblink with A, as create materlised view statment should refer to some table and i used create materlised view on xyz@dblink) BUT when i chekced closely i found that dblink was able to access all the tables in database A. As a start, i revoked all rights... -
Stroing any file in oracle
can somebody give me a snippet as to how can we insert a pdf/xls file into the database??
Many Thanks,
AmitLeave a comment:
-
I know that a LOB field be used to save but i dont know how to insert? Can you please help
Amit...Leave a comment:
-
Hi,
Thanks a lot for the reply. I want to store the entire file.
Cheers,
Amit...Leave a comment:
-
Stroing xls in oracle
Hi,
I want to store one xls file in one of my tables. Requirement is that when i click on a link on some web page, this xls should get opened. Please help me doing that. A sample code will be high help. I am using 9i presently.
Cheers,
Amit -
Getting the table name which is using a sequence
Hi,
I have the sequence names of all teh sequences which are there in my huge database. Now i want to find out which table is using this sequence name (though it will use it through a package/procedure/trigger). For example if i have a sequence as amit and it is being used in a package as below:-
insert into cat_table(sno) values(amit.nex tval);
What i need is the name of the table where it is being used... -
creating a line graph using javascript
Hi,
I need to make a graph using javascript based on the values in the oracle table. Can somebody throw some on it?
Thanks in advance for your help,
Amit -
Inserting 8 lakh records using sqlloader
Hi,
I want to insert 8 lakh records into one table. Table has got around 25 columns. The table has got indexes but before insertion, the indexes are dropped and after the reocrds are run, the indexes are again created. But insertion of these records take around 5- 6 hours. As far as i know, sqlloader should not take this much time. Can anybody tell me what may be the cause of this problem? Is it related to autocommit in sqlloader?... -
Thanks a lot for taking pain. I tried something like below:-
[code=perl]
open(FILE, "amy.csv") ;
my @lines = <FILE>;
close(FILE);
foreach my $line (@lines)
{
next if $line =~ /^\s*$/;
$line =~ tr/ /-/ ;
my @cols = split(/\@/, $line);
print "$cols[1]********$cols[3]*****$cols[4]\n" ;
open(IN, ">>amit.txt ");...Leave a comment:
-
Thanks a lot. I was able to understand it from there :-). May i know your good name please so that instead of a blank "Hi" or "Thanks", i could refer to your name :-).
Thanks again.
Cheers,
Amit...Leave a comment:
-
Hi Jeff,
Thanks a lot for the reply. I always expect a reply from atleast you :-) . I will be using Windows environment as well as Solaris environment.
Suppose i have a file a.txt with 4 rows as shown below:-
*************** *************** *************** *************** **
i@am@amit@and@i @work@in@this@w orld
i@am@amit@and@i @work@in@this@w orld
i@am@amit@and@i @work@in@this@w orld
...Leave a comment:
-
File creation using Perl
Hi,
I want to parse a file and from some of the attributes of this file, i want to create another file using perl. Can anybody suggest me a way out? It would be great if i dont have to use any module. Is it possible? Any sample code will be of a great help to me.
Cheers,
Amit -
How to call sql queries from perl
Hi All,
I want to call simple sql queries from a perl program. Can anybody throw a light as to how can i do that? Do i need to install any type of driver etc? A sample code will be highly appreciated.
Thanks in advance,
Cheers,
Amit -
Thanks very much Jeff.
Cheers,
AmitLeave a comment:
-
How to generate Log Files for perl code
Hi All,
I have writte a perl code. The perl code simple do some calculation and based on that, it takes a specific action for a device. But i do not have any logging mechanism for this. By this i mean that i do not get any logfile for this. I want to generate a logfile for every step which i write in perl code. For example, if i have i have 2 variables and i am doing the sum, this should be logged in a log file. Can you please help... -
Sorry Jeff, there we a typo at my end..
Cheers,
AmitLeave a comment:
No activity results to display
Leave a comment: