Send message from Forms to Lantronix network device [message #523139] |
Thu, 15 September 2011 14:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/52a04b12e4dc5fda6b1b4878bbbceaa0?s=64&d=mm&r=g) |
OraDog
Messages: 2 Registered: September 2011 Location: USA
|
Junior Member |
|
|
Forms Gurus,
Does anyone know if or how I can send a message from Oracle Forms 10g to a Lantronix terminal server? It is a TCP/IP front end to a serial port controlling a warehouse carousel. We want to send a command string to a ip_address:port_number in raw mode. We have tested it using a telnet session. I develop in PL/SQL, just never used forms.
Thanks,
OraDog
|
|
|
Re: Send message from Forms to Lantronix network device [message #523187 is a reply to message #523139] |
Fri, 16 September 2011 01:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
If you know how to do that using PL/SQL, there are two options I can think of: the first one is to create a stored procedure (with certain parameters, I suppose). You'd then call that procedure from a form (for example, through a push button) and pass form item's values to your procedure. It would then send a message.
In this case, a form doesn't have to be state of the art. Wizard would most probably be smart enough to create a "dummy" form, used as an interface to an end user (so you don't have to be a Forms expert).
Another option, which might (or might not) work, is to create a form and include your PL/SQL procedure into form's program units. The rest would be the same - push a button, send a message. Note that not all PL/SQL code (that works on a database server) runs in Forms, as Forms' PL/SQL version is usually a step "behind" the database server's one. So, if you use certain features that are not supported in Forms' PL/SQL, you'd probably be happier with the first option.
|
|
|
|