Without Dynamic Action we can easily call AJAX call back process
Create a Page Process:
- Name: EMP_NAME
- Type : PL/SQL Code
- Source> PL/SQL Code:
1 2 3 4 5 6 7 8 9 10 11 |
declare v_ename varchar2(100); begin select ename into v_ename from emp where empno = APEX_APPLICATION.g_x01; HTP.PRN(v_ename); end; |
- Execute Options > Point: AJAX Callback
- Create 2 Items in the page
- P2_ID
- P2_NAME
Note: in this example my Page ID is 2, in your case Page ID and Item name may be different
- Now go to your Application Page Property
- Locate HTML header
- Now type the below code in the HTML code editor
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<script type="text/javascript"> function fn_get_name() { apex.server.process("EMP_NAME",{x01: $v('P2_ID')}, { dataType: 'text', success: function(pData){$s('P2_NAME',pData);} } ); } </script> |
- Now go the property Text Field “P2_ID”
- Locate Advanced > Custom Attributes
- Type the below code in the custom attribute field
-
1onchange="fn_get_name();"
- Save Changes
- Now Run the Application and Put 7839 Employee ID and you will notice “KING” is showing in the P2_NAME field.
Thank You
Great site you’ve got here..
It’s hard to find good quality writing
like yours nowadays. I honestly appreciate individuals
like you! Take care!!
Its like you read my mind! You appear to know so much about this,
like you wrote the book in it or something. I think that you could do
with some pics to drive the message home a little bit, but other than that,
this is fantastic blog. A great read. I’ll certainly be back.
Hello, just wanted to say, I liked this blog post. It was funny.
Keep on posting!
Thanks for a marvelous posting! I really enjoyed reading it,
you will be a great author. I will always bookmark your blog and will eventually come back down the
road. I want to encourage you continue your great work, have a nice morning!
This design is wicked! You obviously know how to keep a reader entertained.
Between your wit and your videos, I was almost moved
to start my own blog (well, almost…HaHa!) Wonderful job.
I really enjoyed what you had to say, and more than that, how you presented it.
Too cool!
An impressive share! I’ve just forwarded this onto a friend who
has been conducting a little homework on this. And he
actually bought me breakfast simply because I discovered it for him…
lol. So let me reword this…. Thank YOU for the
meal!! But yeah, thanx for spending some time to discuss this topic
here on your web site.
Hurrah! In the end I got a website from where I be capable of genuinely take
helpful information regarding my study and knowledge.
Thank you for every other informative web site. Where else may I am getting
that type of info written in such a perfect approach?
I have a venture that I am simply now working on, and I have
been on the look out for such information.
Hi there very nice web site!! Guy .. Beautiful ..
Superb .. I’ll bookmark your site and take the feeds additionally?
I am happy to seek out so many useful information here in the publish, we need work
out more techniques on this regard, thanks for sharing.
. . . . .
Article writing is also a excitement, if you be familiar with
then you can write if not it is complex to write.
If you are going for best contents like I do, simply pay a
visit this web site all the time since it provides feature contents, thanks
It’s difficult to find experienced people on this topic, however,
you sound like you know what you’re talking about! Thanks
Hi this is somewhat of off topic but I was wondering if blogs
use WYSIWYG editors or if you have to manually code with HTML.
I’m starting a blog soon but have no coding knowledge so I wanted to get guidance from someone with experience.
Any help would be enormously appreciated!
It’s actually a cool and helpful piece of info.
I am glad that you simply shared this useful info with us.
Please stay us informed like this. Thank you for sharing.
Hello my loved one! I wish to say that this article is awesome, great written and come with approximately all vital infos.
I would like to see extra posts like this .
I am sure this piece of writing has touched all the internet users, its really
really good paragraph on building up new weblog.
This post is priceless. When can I find out more?
Keep on writing, great job!
This blog was… how do you say it? Relevant!! Finally
I’ve found something that helped me. Many thanks!
Here is my webpage … cbd lotion
continuously i used to read smaller content which as well clear their motive,
and that is also happening with this article which
I am reading at this place.
бурдж дубай
форум дубай
температура дубай
That is a great tip particularly to those new to the blogosphere.
Simple but very precise info… Many thanks for sharing this one.
A must read article!
Wow, wonderful blog structure! How long have you
been blogging for? you make running a blog look easy.
The whole look of your web site is excellent, as smartly as the content!
Wow, marvelous blog layout! How long have you been bloggihg for?
you made blogging look easy.The overall llook of your webaite
is wonderful, llet alone the content!
php patterns
For newest news you hve to pay a quick visit internet and on world-wide-web I found tis web pagge as a most excellent web
site for newest updates.
php patterns
I’m not sure why but this web site is loading very
slow for me. Is anyone else having this issue or is it a problem
on my end? I’ll check back later on and see if the
problem still exists. white gold bridal set
Hey, you used to write excellent, but the last several
posts have been kinda boring… I miss your great
writings. Past few posts are just a little bit out of track!
come on!
My website Belen
Having read this I thought it was very enlightening.
I appreciate you finding the time and energy to put this information together.
I once again find myself personally spending a lot of time both reading and leaving comments.
But so what, it was still worthwhile!
Also visit my web page; urlki.Com
Write more, thats all I have to say. Literally, it seems as though you relied
on the video to make your point. You definitely know what youre talking about, why throw away your
intelligence on just posting videos to your blog
when you could be giving us something informative to read?
I don’t even know how I ended up here, but I thought this post was great.
I do not know who you are but definitely you are going to a famous blogger if you are not already 😉
Cheers!
I like the helpful information you provide to your articles.
I’ll bookmark your weblog and take a look at again right here regularly.
I am rather certain I will be told many new stuff right here!
Good luck for the following!