NEVER MIND :-)
I got it all to work. Thank you.
brig
Last Activity: Aug 4 '07, 03:17 AM
Joined: Jul 28 '07
Location:
-
Error in Procedure to Create Users. Duplicate name.
Hi All,
I have a Table (STDTable) with 3 columns: STDAccount, STDpassword, IRowId.
I am getting a user conflicts error when I 'get the next' user info from the table. I am using SQLDeveloper.
Below is the procedure and the error that follows. I understand I should not be creating users in the sys schema, but I am still learning and don't know how to make a new schema to put these users into. So for now, this is... -
Hi, Yes I am doing this under SYS. Someone told me I shouldn't use SYS and create tables there. Should I use system?
I also think my code is just wrong. I have changed it many times. I think I need to start over, thinking clearly. Then I will repost if it doesn't work.
Thank you so much for listening and helping :-)
brigLeave a comment:
-
Procedure to create users worked but where are they???
I am very confused. I ran the script below and it worked and was completed. But where are the users it was supposed to create? Am I to do something in addition to running the procedure? I am so sorry if this is a baby question.
Thank you
Brig
SQL> create or replace
2 PROCEDURE makeStudents
3
4 AS
...Leave a comment:
-
Well, all worked fine. Said procedure successfully completed. But no users were created. AM I missing something???Leave a comment:
-
Thank you, that did it. Thank you so much, It was an itch I couldn't scratch for days. :-)Leave a comment:
-
A procedure can not create a user?
I am reading and thinking that a user (or any object) cannot be created within a procedure. Is that correct? I am new to
PL/ SQL, not programming, but do apologize.
I have a StdtTable (in SYS) with 3 columns: account, password, rowid.
I just want to read each row and create a user. This is what I have, does anyone have any idea's? The code is sloppy as I am stuck on the create. :-( Thank you. Oh, I am running this is SQLDeveloper.... -
creating a user within a function
Hi, I am new to sql, so I apologize in advance. I wrote a procedure which calls a function. (I am not sure if the procedure will work yet). MY question is on the function. I am not sure I wrote it correctly as it gives me the Error(10,6): PLS-00103: Encountered the symbol "CREATE" ..
Can you create a user in a function? The procedure reads acct names and passwords from a table, then while its not at the end it creates a user....
No activity results to display
Leave a comment: