I wrote a sample program in notepad


and saved it as p1.sql

i opened sql prompt and gave
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..

Be a part of the DaniWeb community

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