Recent content by swakoo

stored procedure..

my pl/sql hang after executing.. it says it is still executing but the fact is it had already finish it.. any reason?

oh.. thanks.. thats really very valuable..

i had just started learning stored procedure and i am interested in trigger.. can anyone explain to me what is the differents btw procedure and trigger? what is the advantage and disadvantage btw the 2? thanks

i think i got the ans to it.. i tried remove some of the code with i dun need for testing the part which i wanted to test and make it 2996 line. and it works perfectly with the step in.. and next i added afew line to make it 3003 line. this time round it hangs.. haha..

my pl/sql developer hangs whenever i tried to step in the code.. any one know the reason? is it because my code is too long? my code are 3000+ line only.. thanks

hmm... dynamic array means that it can expand according to the to number of records going to insert. in varray, i normally do this: type Record_type is varray(50) of varchar2(500); Record_varray Record_type := Record_type(); as u notice i have to declare the size of the varray. is there any...

for eg: i have a unknown records of string to be stored. eg: Tom Mary Harry ... ... ... i do not know how many record will be retrieved.

hmm.. is it possible to delcare a dynamic array in PL/SQL? something like arraylist in java. thanks

hmmm.. newbie here.. i have a jpg file. how is it possibe for me to write a stored procedure and insert it into a table field declared as blob. thanks

i had this error while trying to read a line from a file. can anyone explain the error to me and if possible give me a solution to solve it.. thanks

yes. there is. i have tried it in pl/sql. dun believe can try for yourself. but the fact is i tried and it satisfy what i needed. my sql only return the rows i want to process. but each row i have to check the condition and process differently. ps. No hard feeling. :)

i found a better way of going.. open cursor loop fetch cursor into v_name exit when cursor%notfound there are afew condition check here. is it possible that if one condition fails straight away procceed to next record instead of finish all the check? if v_name='ABC' then goto next_record; end...

i have a cursor. select name from person open cursor loop fetch cursor into v_name exit when cursor%notfound there are afew condition check here. is it possible that if one condition fails straight away procceed to next record instead of finish all the check? if v_name='ABC' then next record...

can anyone show me how to use it?