469,125 Members | 1,241 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

Procedure explaination

create or replace PROCEDURE draw_welcome_portlet IS theuser VARCHAR2(30) := portal.wwctx_api.get_user;
v_forename VARCHAR2(50);

CURSOR user_cur IS
SELECT initcap(surname || ' ' || forename)
FROM nyp_libportal.library_user
WHERE UPPER(user_id) = UPPER(theuser);
BEGIN

IF theuser <> 'PUBLIC' THEN

OPEN user_cur;
LOOP
FETCH user_cur
INTO v_forename;
EXIT
WHEN user_cur % NOTFOUND;
END LOOP;

CLOSE user_cur;

htp.p('<SPAN STYLE="FONT-SIZE: 9pt; FONT-FAMILY: Verdana"><B> Welcome ' || v_forename || '</B></SPAN>');
ELSE
htp.p('');
END IF;

EXCEPTION
WHEN portal.wwctx_api.no_session_exception THEN
htp.p('Error: Session not initiated.');
WHEN others THEN
NULL;
END;


Hi,

What is the above procedure coding about?
Jul 12 '07 #1
1 1454
debasisdas
8,127 Expert 4TB
this procedure is used for web programing.

and please do not post code written by others, of which u have no idea.

even if i explain the same to u , u will get nothing out of it.
Jul 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Thiemo Kellner | last post: by
2 posts views Thread by Dino L. | last post: by
reply views Thread by SOI_0152 | last post: by
9 posts views Thread by JJ297 | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.