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

Report message to a moderator

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: 7065
Registered: December 2001
Senior Member
You need to post some code if you want help on this one. Your code contains an error.

MHE

Report message to a moderator

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;

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
exec is a sqlplus keyword. Remove it.

Report message to a moderator

Previous Topic: Common Login for 2 different applications in 2 different workspaces
Next Topic: owa_cookie encrypt cookie
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 08:49:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.