Jump to content


red

Member Since 07 Nov 2006
Offline Last Active Nov 13 2006 08:18 PM
-----

Topics I've Started

CRT and Logon

12 November 2006 - 09:57 AM

Hi all,
I have a problem when i print to file with a printer mapping setup.

I put an exmaple :

Proiv Printer : LP1
Windows Printer : FILE
Device File Name : c:\tmp\proiv_print.txt

It's all ok till use a width column report max 80 (columns).
If i use a report with plus 80 columns the system truncate the report to 80.
Because for this report the system use the CRT Width in function "$CRT" with a terminal "GUIDEV"
The default setting is "50" in Exedecimal that corrispondig to "80" in decimal, ok
i have a solution if you set in "E9" (correspondig to 233 in decimal) , the system prints the report correctly.

But the next logon the new window logon show me out of the main screen.




I have a problem to send the attachments print screen.

I explain with a char mode
Logon : (The little box is a logon)
|----------------------------------|
| |
| |-------|
| |Company|
| |User |
| |Passwor|
| |-------|
| |
| |
|----------------------------------|



There is a solutions?

best regards
Red
[/b]

Oracle and Procedure and Parameters

08 November 2006 - 10:09 AM

Hi all,
i have a problem,
I have procedure in oracle with one parameter in input and one parameter in output.

Example:

create or replace procedure prova_proiv(p_in in varchar2, p_out out varchar2) is
begin
if nvl(p_in, [email=""]'@'[/email]) = 'A' then
p_out:='0';
else
p_out:='1';
end if;
end prova_proiv;


In proiv how can receive a parameters?

$PAR1 = 'C'
$PAR2 = ''
SQL
DECLARE PAR VARCHAR2(1) :=:$PAR1;
DECLARE TOR VARCHAR2(1) :=:$PAR2;
BEGIN
CALL PROVA_PROIV(PAR,TOR);
END;
ENDSQL

UMSG('$PAR1:' + $PAR1 + '-' + $PAR2,-1)


REGARDS IN ADVANCE
RED