This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button
Course Of The Month
6 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
without specifying field names in oracle cursor
Posted on 2011-03-23
Dear Friends
For Data Migration purpose, i need to compare various complex queries between source and target environments
I am getting out of memory error when bulk volume of transactions are involved.
If i check one primary key value in those complex queries using cursor, i will not get out of memory error
is it possible to display field values in cursor without specifiying fieldnames from cursor in dbms_output.put_line statement in oracle procedure ?
Please help me
Regards
Sathya Narayanan
For Data Migration purpose, i need to compare various complex queries between source and target environments
I am getting out of memory error when bulk volume of transactions are involved.
If i check one primary key value in those complex queries using cursor, i will not get out of memory error
is it possible to display field values in cursor without specifiying fieldnames from cursor in dbms_output.put_line statement in oracle procedure ?
Please help me
Regards
Sathya Narayanan
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Active today
For comparison purpose, as long as you aren't picky about the output, check out the code I wrote in another question:
http://www.experts-exchange.com/Database/Oracle/Q_26843082.html?#a34966249
http://www.experts-exchange.com/Database/Oracle/Q_26843082.html?#a34966249
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month6 days, 5 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
707 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.