Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » HTML_DB please help on this
icon4.gif  HTML_DB please help on this [message #208791] Tue, 12 December 2006 04:46 Go to next message
prasanna_anbu
Messages: 34
Registered: November 2006
Location: india
Member
i tried to execute pl/sql procedure in sqlcomand in HTMLDB but
the following error is occur

ORA-06550: line 2, column 6:
PLS-00103: Encountered the symbol "DBMS_MVIEW" when expecting one of the following:

:= . ( @ % ;
The symbol ":=" was substituted for "DBMS_MVIEW" to continue.1. BEGIN
2. EXEC DBMS_MVIEW.REFRESH('MVIEW_FI_1', 'C');
3. END;

how can solve it
Re: HTML_DB please help on this [message #208800 is a reply to message #208791] Tue, 12 December 2006 04:58 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You need to post some code if you want help on this one. Your code contains an error.

MHE
Re: HTML_DB please help on this [message #208829 is a reply to message #208800] Tue, 12 December 2006 05:52 Go to previous messageGo to next message
prasanna_anbu
Messages: 34
Registered: November 2006
Location: india
Member
BEGIN
EXEC DBMS_MVIEW.REFRESH('MVIEW_FI_1', 'C');
END;
Re: HTML_DB please help on this [message #208835 is a reply to message #208829] Tue, 12 December 2006 06:01 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
exec is a sqlplus keyword. Remove it.
Previous Topic: Common Login for 2 different applications in 2 different workspaces
Next Topic: owa_cookie encrypt cookie
Goto Forum:
  


Current Time: Fri Dec 09 05:52:47 CST 2016

Total time taken to generate the page: 0.17363 seconds