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

Recommended Answers

All 3 Replies

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..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.