I wrote a sample program in notepad
begin
dbms_output.put_line('welcome');
end;
/
and saved it as p1.sql
i opened sql prompt and gave
@p1
it didnt worked???
i tried exec p1;
still not working??
how to execute a pl/sql program???pls help
I wrote a sample program in notepad
begin
dbms_output.put_line('welcome');
end;
/
and saved it as p1.sql
i opened sql prompt and gave
@p1
it didnt worked???
i tried exec p1;
still not working??
how to execute a pl/sql program???pls help
Is the dbms_output
enabled? If you run show errors
do you get any information?
how to enable that dbms_output?? it is showing
ERROR at Line1
Identifier p1 must be declared.
Ok I got it
i did spelling mistake in my code..
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.