Members
Search
Help
Register
Login
Home
Home
»
Developer & Programmer
»
Forms
»
dyamic alert ?
(Form 6i)
Show:
Today's Messages
::
Show Polls
::
Message Navigator
E-mail to friend
dyamic alert ?
[message #319371]
Sat, 10 May 2008 03:23
mm_kanish05
Messages:
240
Registered:
January 2007
Location:
Chennai
Senior Member
Hi
I Want to Change message alert in dynamically (ie message)
How please Guide me
Thanks
wbr
kanish
Report message to a moderator
Re: dyamic alert ?
[message #319408
is a reply to message #319371
]
Sat, 10 May 2008 14:28
Littlefoot
Messages:
6159
Registered:
June 2005
Location:
Croatia, Europe
Senior Member
I'm sorry, but I didn't understand what you want to do.
What do you have now? What do you want to have?
Report message to a moderator
Re: dyamic alert ?
[message #319413
is a reply to message #319371
]
Sat, 10 May 2008 14:52
urnikhil
Messages:
23
Registered:
March 2008
Junior Member
Hey Kanish,
The following example will guide you...
** Built-in: SET_ALERT_PROPERTY
** Example: Places the error message into a user-defined alert
** named 'My_Error_Alert' and displays the alert.
** Trigger: On-Error
*/
DECLARE
err_txt VARCHAR2(80) := Error_Text;
al_id ALERT;
al_button Number;
BEGIN
al_id := FIND_ALERT('My_Error_Alert');
SET_ALERT_PROPERTY(al_id, alert_message_text, err_txt );
al_button := SHOW_ALERT( al_id );
END;
Let me know if this is not what you are looking for...
- Nik...
Report message to a moderator
Re: dyamic alert ?
[message #319492
is a reply to message #319371
]
Sun, 11 May 2008 22:06
mm_kanish05
Messages:
240
Registered:
January 2007
Location:
Chennai
Senior Member
Thanks for all you people
i had done it already.
kanish
Report message to a moderator
Previous Topic:
calculate
Next Topic:
How to Store Photos in Oracle
Goto Forum:
- SQL & PL/SQL
SQL & PL/SQL
Client Tools
- RDBMS Server
Server Administration
Backup & Recovery
Performance Tuning
Security
Networking and Gateways
Enterprise Manager
Server Utilities
- Server Options
RAC & Failsafe
Data Guard
Replication
Streams & AQ
Spatial
Text & interMedia
- Developer & Programmer
Application Express & MOD_PLSQL
Forms
Reports & Discoverer
Designer
JDeveloper, Java & XML
Warehouse Builder
Precompilers, OCI & OCCI
Open Database Interfaces
- Fusion Middleware & Colab Suite
Application Server
Business Intelligence
Portal & WebCenter Suite
Collaboration & Content Management
- Applications
Oracle Fusion Apps & E-Business Suite
PeopleSoft, JD Edwards & Siebel
Other Application Suites
- Platforms
Unix
Linux
Windows
OS/390, z/Linux & AS/400
Other Operating Systems
- Other
General
Homework, Training & Certification
Marketplace
Community Hangout
Suggestions & Feedback
Test
- Non-English Forums
Arabic
Dutch
French
German
Japanese
Portuguese
Russian
Spanish
-=]
Back to Top
[=-
[
Syndicate this forum (XML)
] [
]
Current Time:
Thu Jul 24 02:58:45 CDT 2008
Total time taken to generate the page: 0.08110 seconds
.::
Forum Home
::
Site Home
::
Wiki Home
::
Contact
::
Privacy
::.