Ask me a question and I shall try to reach you as soon as possible
here is my problem in detail:
I have table test_table.
create table test_table1 (a number primary key, b number, c number);
I have the below function in a remote DB. This function is fetching a record from test_table and returning this to calling program.
create or replace function gettesttablerec(p_a number)
return test_table%rowtype is
where a = p_a;
when others then
I have below procedure here in my DB. Where I am trying to call above function from remote DB (through DB link) and insert the same record in another table with same structure. I have written below procedure but giving me some compilation issue. Probably I have never tried such things before so dont have idea about the proper syntax of that.
create or replace procedure insertintonewtable(p_a number) is
execute immediate ‘begin :RETVAL := gettesttablerec(:1)@; end;’
using IN p_a, OUT v_testtablerec;
insert into test_table1
I hope above info would be sufficient to answer my question, if you you still feel that this not enough please do let me know.
Bold part is the problematic area.
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.
Notify me of new posts via email.
Database Enthusiast, Author, Speaker and blogger
View Full Profile →
Advanced Oracle PL/SQL Developer's Guide - Second Edition
Oracle Advanced PL/SQL Developer Professional Guide
Enter your email address to follow this blog and receive notifications of new posts by email.
Join 780 other followers
Saurabh K. Gupta's Oracle Blog
Blog at WordPress.com.