The following function could take two point's coordinates and return a line. Do you think this solves your problem now?
FUNCTION xy2line ( pi_x1 number, pi_y1 number, pi_x2 number, pi_y2 number, srid NUMBER DEFAULT null )
Line mdsys.sdo_geometry ;
Line := Mdsys.Sdo_geometry( 2002, SRID, null,
MDSYS.SDO_ELEM_INFO_ARRAY(1, 2, 1),
MDSYS.SDO_ORDINATE_ARRAY( pi_x1, pi_y1, pi_x2,pi_y2 ) );
You that answeres it, I was just hoping for some sdo function that would take it n points, but that will work. It is better then trying to take apart the points and then run them through wkt.
Thanks so much.