Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding remote printer to non-global zone

KMcGregorJun 6 2013 — edited Jun 7 2013
I have a non-global zone with a remote printer defined, and lpstat shows
# lpstat -lp abcdef
printer abcdef disabled since Thu Jun 06 13:18:43 2013. available.

Remote Name: abcdef
Remote Server: 192.168.x.x

On another non-global zone I want to print to the same printer. I referred to the Solaris Printing SAG, and I thought all I had to do is
lpadmin -p abcdef -s abcdefserver

but lpstat -lp abcdef gives
Failed to get printer info for abcdef: not-found

The zone is
SunOS myzone 5.10 Generic_142909-17 sun4u sparc SUNW,Sun-Fire-V490

and the destination (abcdefserver) is a Windows server with the LPD service installed.

What else do I have to do? I can ping and telnet abcdefserver:515, so the network part seems to be fine.

Comments

unknown-7404

In a package, I have a function to retrieve a list of records in a refcursor.

Just for clarification a cursor DOES NOT contain data. It is just a pointer you can use to FETCH data.

The records are of type "user defined type"

When I execute this function, the output variables log shows that my <Return Value> --> value

as one column of my_user_defined_type(columnA, columnB, ...)

The
values displayed are
"oracle.jdbc.proxy.oracle$1proxy$1NullProxy$2java$1sql$2Struct$$$Proxy@<an
hexadecimal value per record>

Ok - what would expect a pointer to look like?

There IS NO DATA until something/someone does a FETCH on the cursor.

1. I have a list of the top ten movies for 2016 and provide a telephone number you can use to get the list

2. You write a function to retrieve a telephone number you can use to get that list.

3. You execute the function.

Ok - all you have is the telephone number. Specifically you DO NOT have the list.

If you want the list you have to CALL the telephone number and FETCH the list.

Yanovic

Wow!

What a brilliant answer!

Really!

I did not know about that!

Try to be more nice in your reply

Yanovic

ok.

I want to understand why I cannot see this function result in SQL Developper under the Output Variables - log

Function retrieve_list  return ref cursor

IS

  Type t_ref_cursor is ref cursor

  v_ref_cursor t_ref_cursor

begin

  open  v_ref_cursor  for

   select my_user_defined_type (columnA, columnB)

   from table zzz;

return v_ref_cursor ;

end;

But it works if i remove the constructor (user defined type) in the query...like this

Function retrieve_list  return ref cursor

IS

  Type t_ref_cursor is ref cursor

  v_ref_cursor t_ref_cursor

begin

  open  v_ref_cursor  for

   select columnA, columnB

   from table zzz;

return v_ref_cursor ;

end;

Yanovic

Here are screeshot from SQL Developer of what i'm saying.

With User defined type :

with_user_defined_type.jpg

Without User defined type :

without_user_defined_type.jpg

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2013
Added on Jun 6 2013
1 comment
1,105 views