Today's Messages (off)  | Unanswered Messages (on)

Forum: Reports & Discoverer
 Topic: Send report directly to network printer
icon8.gif  Send report directly to network printer [message #681538] Wed, 29 July 2020 01:14
a.mughees0009
Messages: 1
Registered: July 2020
Junior Member
Hi Friends! I'm searching something I couldn't search on internet for days.

Please guide me how to send report print directly to the printer without printing on screen.
I'm developing a POS system and need to print invoice

Here is the code I'm using, I guess I'm stuck on 'report_desname'

SET_REPORT_OBJECT_PROPERTY ('REP_OBJ',
REPORT_FILENAME,
PATH || REPORT_NAME || '.rdf');
V_REP_NAME := 'REP_OBJ';
V_REPID := FIND_REPORT_OBJECT (V_REP_NAME);
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_DESTYPE, PRINTER);
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_DESNAME, '\\172.16.6.12\HP LaserJet P2050 Series PCL6');
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_DESFORMAT,'dflt');
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_SERVER, REPORT);

Best Regards.
Forum: Forms
 Topic: Image Rotation in Oracle form (11g)
Image Rotation in Oracle form (11g) [message #681533] Tue, 28 July 2020 01:36
mahmud732
Messages: 81
Registered: October 2009
Location: Dhaka
Member
How can I rotate an image loaded in forms runtime.

Advance thanks to all.

Regards

Sultan Mahmud
Forum: Client Tools
 Topic: SqlDeveloper tools in a secure environment
SqlDeveloper tools in a secure environment [message #681559] Tue, 04 August 2020 02:13
keenweng2001
Messages: 6
Registered: August 2020
Junior Member
we have a number of programmer who want to connect to the ORACLE Instance using SQLDeveloper. is there a way to force the 2FA (password + token) authentication when they login to the instance through the SQL Developer ?
Forum: NoSQL
 Topic: Latest month Partition in hive
Latest month Partition in hive [message #681546] Wed, 29 July 2020 11:39
rohit_shinez
Messages: 139
Registered: January 2015
Senior Member
Hi Guys
I have a table in hive that holds daily date partition column

[code][
My_tab
part_col
2020-03-31
2020-03-30
2020-03-29
2020-04-30
2020-04-29
2020-04-28

/code]
I need the latest partition value i.e. 2020-03-30 reason being 2020-03-31 doesn't hold data. So latest month partition that holds data if i pass 2020-03 i.e.(YYYY-MM)



Current Time: Sat Aug 08 04:12:33 CDT 2020