Procedure Compilation
Hi Friends,
Have a small glitch and hence hope you will spare me a moment.
Have a small procedure and it is not compiling. Could you just have a look and let me know why ?
Thank You, :)
Friend33
PROCEDURE
Create or replace procedure proc_name IS
Pwd varchar2(8);
user varchar2(8);
v_email varchar2(40);
BEGIN
Create or replace FUNCTION new_password RETURN VARCHAR IS
only_alpha_characters CONSTANT VARCHAR2 (1) := 'A';
BEGIN
--Get a random alphanumeric string 10 characters
long
DBMS_RANDOM.SEED (TO_CHAR (SYSDATE, 'MM-DD-YYYY
HH24:MI:SS'));
RETURN DBMS_RANDOM.STRING (only_alpha_characters, 8);
END new_password;
END proc_name;
Software/Hardware used:
Software/Hardware used:
ASKED:
December 7, 2005 4:58 AM
UPDATED:
December 7, 2005 7:32 AM
Answer Wiki:
If you are going to embed a FUNCTION in a PROCEDURE, then it doesn't have "CREATE OR REPLACE" and it must be in the declaration section:
Create or replace procedure proc_name IS
Pwd varchar2(8);
user varchar2(8);
v_email varchar2(40);
FUNCTION new_password RETURN VARCHAR IS
only_alpha_characters CONSTANT VARCHAR2 (1) := 'A';
BEGIN
--Get a random alphanumeric string 10 characters
long
DBMS_RANDOM.SEED (TO_CHAR (SYSDATE, 'MM-DD-YYYY
HH24:MI:SS'));
RETURN DBMS_RANDOM.STRING (only_alpha_characters, 8);
-- You said 10 characters, but this has "8" as a parameter???
END new_password;
BEGIN
null; --Put some good stuff here.
END proc_name;
/
I hope this helps!!!
((MrO))
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
