text item in Oracle forms [message #472572] |
Sun, 22 August 2010 13:04 |
gallonegro
Messages: 3 Registered: August 2010 Location: MONTERREY
|
Junior Member |
|
|
How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.
Hopefully that can help me or suggest a page where consultation
sorry for my English.
Greetings and thanks.
|
|
|
|
|
Re: text item in Oracle forms [message #472591 is a reply to message #472588] |
Sun, 22 August 2010 15:45 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
1) Have a read of the orafaq forum guide - that'll tell you the best way to post code (using [code] tags).
2) You don't need the variable, you can pass the text-item directly:
reportes_package.insert_tabla_temporal_plazavo(:temp_tabla_plazavo.text_item6);
3) Always type variables and parameters to the appropriate table where possible. So:
(tplaza IN plazavo.plaza%TYPE)
4) If you are going to loop over a cursor use a FOR LOOP.
5) That procedure could be rewritten as a single insert/select statement.
|
|
|
|